TransferDatabase...

[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

 

[Dennis]

MS Access isn't a valid type as the error suggests. The correct sysntax is

DoCmd.TransferDatabase acImport, "Microsoft Access", ..... etc.

 

[Mo]

MS Access isn't a valid type as the error suggests. The correct sysntax is

DoCmd.TransferDatabase acImport, "Microsoft Access", ..... etc.

Doh!

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

Thanks Dennis.