Transfering Records

D

DS

I'm trying to Transfer data from one Database to Another Database. Both
have identical tables. I'm getting an error message sayimg that it can't
delete because its involved it another relationship. I'm not trying to
delete just merely transfer. What am I doing wrong?
Thanks
DS

DoCmd.TransferDatabase acExport, "Microsoft Access",
"C:\PROSERV\History\History.mdb", acTable, "tblCheckDetails",
"tblCheckDetails", False
 
M

Maurice

If you get this error why not use a append query instead. If I read correctly
you only want to transfer 1 table? How about an append query. Select all
field within the query and then choose the appropriate table (Browse.. for
designated MDB) and then appropriate table. Should do the same...

Maurice
 

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

Another docmd.Transferdatabase question 0
Stopping a code to delete a table 2
Can DoCmd.TransferDatabase be used to move table to BE 6
transferdatabase error 2
Problem with TransferDatabase export from back end 3
Reports From 2 Databases 6
Transfer/export tables to another DB 6
Transferdatabase Export 1

Top