ADO/DAO Database Copy Structure and Records
G Choquette
(4 Submissions)
Databases/Data Access/DAO/ADO
Visual Basic 3.0
Intermediate
Wed 3rd February 2021
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
Returns
An Access database that copies all the tables and records from another database.
Rate ADO/DAO Database Copy Structure and Records
(8(8 Vote))
(8(8 Vote))
Active Server Pages
Coding Standards
Complete Applications
Custom Controls
Data Structures
Databases / ADO
DDE
Debugging & Errors
DirectX
Encryption
Files / I/O
Games
Graphics
Internet / HTML
Jokes / Humor
Libraries
Math / Dates
Office / VBA
Miscellaneous
OOP
OLE / COM / ActiveX
Registry
Sound / MP3
String Manipulation
VB Enhancements
Windows API
Windows CE
System Services