TransferDatabase (1 Viewer)

I have a DB that acts as a 'Backing up' application. I want to export the table in one database on my network (mapped drives) to another DB on the network.
I've tried this code, but it will only work on the PC where the source DB is, and I don't want that:


Any Ideas?

TIA
TACieslik

Try this out.

DoCmd.TransferDatabase acExport, "Microsoft Access", _
"H:\Projects\SSSS.mdb", acTable, _
"tblInventorySource", "tblInventoryDest", False, False

H:\ is your mapped drive.

Or use UNC instead.

DoCmd.TransferDatabase acExport, "Microsoft Access", _
"\\ServerName\Projects\SSSS.mdb", acTable, _
"tblInventorySource", "tblInventoryDest", False, False

Make sure you have Write permission in the Projects folder.

Thanks for the reply Tim K,

I do understand these file path conventions, but this does not help my problem.
As I explained, I'm using a 3rd Access application to do the 'Backing up'.

Anyway, the problem is solved. I was tring to do too many things with one bit of code. I now do an import of the data, then an export and then I delete the temp table. This was, the stucture of the table is kept along with the data.

Many Thanks,
tacieslik