Creating a Database with VBA
 

Can a database be created using late binding with DAO? I havn't been
successful in doing it. If not, can a database be created with ADO? If so,
what is the code?

Creating a Database with VBA
 

"Philip Spitzer" wrote in message
...
Can a database be created using late binding with DAO? I havn't been
successful in doing it. If not, can a database be created with ADO? If so,
what is the code?



In my opinion, ADO is better if you want to connect to a database like
Access or SQL Server. Search for "Access" in this ng and you will find a
couple of links. What is it that you want to do?

/Fredrik

Creating a Database with VBA
 

Philip Spitzer wrote:
Can a database be created using late binding with DAO? I havn't been
successful in doing it. If not, can a database be created with ADO?
If so,
what is the code?

Set Cat = CreateObject("ADOX.Catalog")
Cat.Create _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\New_Jet_DB.mdb"

Jamie.

--