Transfering Records

  • Thread starter Thread starter DS
  • Start date Start date
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
 
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
 
Back
Top