TransferDatabase...

  • Thread starter Thread starter Mo
  • Start date Start date
M

Mo

I'm using the following code to import a table from another Access db
into the current one:

----

DoCmd.TransferDatabase acImport, "MS Access",
"C:\ProgramFiles\PsychCorpCenter\Report Data Mark2\AS_REP.mdb", acTable,
"tblTempReport", "tblTempReport"

-----

And keep getting the error below. I've verified that the database and
database object I want to import all exist in the correct locations, so
what's the problem?

TIA,

Error: Runtime Error 2507. The ms access type isn't an installed
database or doesn't support the operation you chose
 
MS Access isn't a valid type as the error suggests. The correct sysntax is

DoCmd.TransferDatabase acImport, "Microsoft Access", ..... etc.
 
Dennis said:
MS Access isn't a valid type as the error suggests. The correct sysntax is

DoCmd.TransferDatabase acImport, "Microsoft Access", ..... etc.
Click to expand...

Doh!

That actually would have been quite funny, if it hadn't been so frustrating!

Thanks Dennis.
 
Back
Top