• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• ADO/DAO Database Copy Structure and Records

ADO/DAO Database Copy Structure and Records

by G Choquette (4 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Intermediate
Date Added: Wed 3^rd February 2021
Rating: (7 Votes)

Copy the table structures and records from one database to another. In my case, I use this code to copy from an ODBC SQL Server database to a local Access to allow users access to a copy of the data when they are not connected to the network.

Inputs
The user will have to edit the database names and provider strings to match their own database files
Code Returns
An Access database that copies all the tables and records from another database.

Download this snippet    Add to My Saved Code

ADO/DAO Database Copy Structure and Records Comments

No comments have been posted about ADO/DAO Database Copy Structure and Records. Why not be the first to post a comment about ADO/DAO Database Copy Structure and Records.

Post your comment