Create Access File through ODBC

[Lupina]

Hi

How to create new empty MS Access file through ODBC,
and next how to create new table?

Thanks

 

[news.microsoft.com]

Actually I don't think you can. What I would do is create a templdate mdf
file. Use code to copy it and write a module for DDL.

HTH,

Nick Harris, MCSD

 

[Lupina]

Ok, so is another way to do it?
I have to stress that , it would be a new file with new table.

 

[Jim Hughes]

Add a reference to the COM Microsoft DAO 3.6 Object Library.

Dim dbe As New dao.DBEngine
dbe.CreateDatabase("db1.mdb", dao.LanguageConstants.dbLangGeneral)

dbe = Nothing