Gerry:
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.
Thanks
sherry