TransfertDatabase

  • Thread starter Thread starter pierre-yves.ste-marie
  • Start date Start date
P

pierre-yves.ste-marie

I use the method TansfertDatabase to export a table to another mdb:
DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\First.mdb",
acTable, "Table999", "Table999"

But how do I correct this line if the First.mdb as a password=ABC??

Best regards.
 
You need to first opne database using
dbengine.opendatabase
supplying password (see access help)
and then run
DoCmd.TransferDatabase

--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com



I use the method TansfertDatabase to export a table to another mdb:
DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\First.mdb",
acTable, "Table999", "Table999"

But how do I correct this line if the First.mdb as a password=ABC??

Best regards.
 
Back
Top