Creating .MDB in ADO; copying a table structure 
Author Message
 Creating .MDB in ADO; copying a table structure

I can create a new Access database file using the CreateDatabase method in
DAO with no problem.  However, I am new to ADO, and am trying to figure out
how to accomplish the same task in ADO.  Anyone have a suggestion?

Also, I need to copy the structure of an existing table in one .MDB to
create a new, empty table in the newly-created .MDB described above.  Does
ADO handle this any better than the CopyStruct function in VisData?

Any help is appreciated.

Sat, 08 Jun 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Is there a way to export an .MDB table structure to SQL create statments

2. create a copy of sql database structures using ADO in visual basic

3. help: vb 6.0 / ado code to copy a table from one mdb to another

4. Copy a table from Template.mdb to existing.mdb

5. HowTo Copy a Recordset from a Table to an identically structured table

6. Copying the structure of a table to a new table

7. Access locks when opening a table in an ADO created MDB

8. Copying the structure of one Access table to a new Access table

9. Copying MDB structure withing code

10. Copying the database structure of a MDB file in VB5

11. copy mdb base structure to new one from vb6

12. Copying the database structure of a MDB file in VB5


Powered by phpBB® Forum Software