Export Tables

[Eddie Mason]

Hi All,

I need to add two tables with a one to many relationship to a clients database. I could Email them a database containing the two tables and then phone them and take them through the import procedure, but I would prefer if it’s possible to have them simply open a database and it automatically export the two tables and the relationship.

Is it possible to do this?

Hope someone can help

Regards,

Eddie

 

[Carnafex]

This wont create the relationships between the tables, but you can export all the tables themselves using this method:

DoCmd.TransferDatabase acExport, "Microsoft Access", _
   "C:\DataBaseToExportTo.mdb", _
   acTable, _
   "SourceTableName", _
   "DestinationTableName"

So use this code inside the database you give to the people. You can also swap its function and set it to acImport, and then run the import code from inside the database they already have.
Check the VB help for more info on the method, theres quite a bit of info on this.

Hopefully that helps a bit, and Ill see if theres any way to get the relationships to work.
Ta

Jason

 

[Eddie Mason]

Hi Jason

Many thanks for the advice.

Regards

Eddie