Export Access Backend table to other database 1

[chtullu]

Hello,

I'm currently using a split database and I want to be able to permit a user to export a table from the backend to another database via a command button on the front end. When I execute the following code from the front end
only the link to the table is exported. I want to be able to export the actual table to another database

DoCmd.TransferDatabase acExport, "Microsoft Access", "I:\PBS\Rabs-DB\Test.mdb", acTable, "SLockbox54602Table", "SLockbox54602Table"

 

[fredericofonseca]

Works fine with Access 2003. Table and data are copied, not just the link.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[chtullu]

Hello,

I'm currently using Access 97, which I should have mentioned. The table needs to be exported to another database where it will be scanned. Linking doesn't work because the source databases are secured and part of workgroups. When the linked table is exported, the permission structure is also exported. By exporting the table, only the data and table structure is exported, not the permission structure, which is fine.

 

[PHV]

You may export the result of a maketable query based on the linked table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244