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.