TransferDatabase...

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
 
D

Dennis

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

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

Mo

Dennis said:
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.
 

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

Top