Copy Table to Backend database

N

neshev

Hi Guys.
I have a database that staff use offline on their laptops when they are away
from the office. When they return to the office, the database copies tables
from a master database on the server such as contact names etc. I use the
following code to copy the table.
LFilename = “G:\MasterDB.mdb"

DoCmd.TransferDatabase acImport, "Microsoft Access", LFilename, acTable,
"Tbl_Contacts", "Tbl_Contacts", False

The problem that i have is that the database on the laptop is now split so I
need to copy the table to the backend database. Is there a way that I can
specify the path to the backend and copy the table to there.

Thanks in advance,

Neil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generate a new backend 2
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Access 2007 security warning with DoCmd.TransferDatabase 1
security warning in access 2007 copying query with doCmd.transferdatabase 0
Macro to copy table of contents to a new doc 0
Automate Import of Spreadsheet to Backend from Frontend 1
How can I TransferDatabase a backend table from the frontend? 2
Dealing with a Pivot Table (when I don't want to) 0

Top