How to create a NEW ADO database using Jet

[DGA15]

How can I create a new ADO-Jet database? Once created I know how to add the tables, fields, etc. but I cannot seem to create a new, empty database from VB6 code.

 

[Foada]

Add a reference to the Microsoft ADO Ext 2.6 for Dll and Security and then use the following code:

Sub CreateDatabase()

Dim cat As New ADOX.Catalog
cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\new.mdb"

End Sub

Hope this helps Anything is possible, the problem is I only have one lifetime.

 

[CasperTFG]

I know I once had a really good reply on this but I can't find it...

anyway here are 2 other links that might be helpful.
thread222-80959 thread222-60995 Craig, mailto:sander@cogeco.ca

Remember not to name the Lambs...
It only makes the chops harder to swallow

 

[DGA15]

foda, thanks for the help