Board index » VB & Database

All times are UTC



 VB5 & Access 97 Copy Table Structure from One MDB to Another 
Author Message
Ben Kinse
#1 / 2
 VB5 & Access 97 Copy Table Structure from One MDB to Another

Does anyone have sample code that copies a table (structure only) from one
MDB to another using Visual Basic 5 and Access 97 databases?


Mon, 27 Jan 2003 03:00:00 GMT  
JohnFo
#2 / 2
 VB5 & Access 97 Copy Table Structure from One MDB to Another

There may be exact code out there, however if the MDB doesn't have too much
data, you can use the CompactDatabase method of DBEngine to create a copy of
the MDB. Then, you can simply loop through all tables issuing a "Delete *
from .." as you go.

Quote:

>Does anyone have sample code that copies a table (structure only) from one
>MDB to another using Visual Basic 5 and Access 97 databases?



Tue, 28 Jan 2003 03:00:00 GMT  
 
 Page 1 of 1
  [ 2 post ] 

 Relevant Pages 

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

2. ADO Copy Tables from One Database to Another (Access 97)

3. vba code to copy table from access 97 to excel 97

4. copy mdb base structure to new one from vb6

5. Creating .MDB in ADO; copying a table structure

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

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

8. TransferDatabase method from Access 95 mdb to Access 97 mdb

9. need to copy data from one field to another in access 97

10. COPY TABLE FROM ONE MDB TO ANOTHER

11. Copy a table from one Database (AS400 or SQL server) to another (MDB)

12. Copying MDB Table from One File to Another?

  

 
Powered by phpBB® Forum Software