Transfer Database not working

[Bill (Unique as my name)]

Access cues me for the database password. I enter it correctly. The
import cancels. The f drive is a portable lexar usb drive.

Thank you in advance.


Function f112()
On Error GoTo f112_Err

DoCmd.TransferDatabase acImport, "Microsoft Access",
"f:\fm\fm.mdb", acTable, "c:\fm\fm.mdb", "tova", False

f112_Exit:
Exit Function

f112_Err:
MsgBox Error$
Resume Macro2_Exit

End Function


Access rarely lets me down,
or gives me cause to frown,
But this time it has got me stumped.
My head spins round and round.

 

[gee664]

What happens with an import from the c: drive? It works?

 

[Bill (Unique as my name)]

No. I gave it a try. It works in Excel from both the f and c drives.
For now, I think I'll just accept this as one of Access's anomolies. I
can pop the table into a sheet and import it from there.

Thanks for the response.