I want to use code to create a new Access Database. I know how to do this using DAO object, but I am now using ADO and cannot see how to accomplish this task. In DAO I would just use a 'set myDB = OpenDatabase(DBName, true)' and then I could create the tables using SQL statements. How do I do this with ADO?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
