transfer database acimport

[mikeba1]

I am trying to transfer (copy) a table from one mdb to the current db.
Here is the code
DoCmd.TransferDatabase acImport, "Microsoft Access", "c:\newmembers\centremembersdata.mdb", acTable, "members", "copymembers"


no errors no transfer!!!!

any ideas

thanks

 

[dhookom]

I copied and pasted the code into my Access database (2007) and it work as expected.

Duane
Hook'D on Access
MS Access MVP

 

[mikeba1]

Sorry false alarm
The code I intended to be 'on click' however finger trouble and it was 'on double click'

Age catching up !!