Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Automation for making a replicate MS ACCESS database
Message
De
06/08/2001 15:20:34
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00539319
Message ID:
00540337
Vues:
25
Thanks for your respond. I have a question: since I use ODBC commands to update the records in the mdb file (sqlexe commands), is there any odbc commands that I can use to create a database and copy the existing tables structures to the new database ? What is it really doing with the tool we got from the company for building the transfter mdb file is making a copy of the selected records to the new mdb file. I think that it will be fare easy for me if there is a command that I create use to create a database and copy the data structures of existing tables and use sqlexec to insert records to each table.

I'm not aware of any SQLEXEC commands that will "create a database" or easily add a table (since you need the table structure). These initial operations are typically done using DAO or ADO. If you want to determine the capabilities of the Access ODBC driver, then you will need to consult the Microsoft Jet SQL Reference.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform