Transfer Database not working

#1 (**permalink**) 28-Jul-2006, 08:08 AM

Access cues me for the database password. I enter it correctly. The
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9954-transfer-database-not-working.html
import cancels. The f drive is a portable lexar usb drive.

Thank you in advance.

Function f112()
On Error GoTo f112_Err
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9954

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.

#2 (**permalink**) 28-Jul-2006, 08:09 AM

What happens with an import from the c: drive? It works?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9954

#3 (**permalink**) 28-Jul-2006, 08:09 AM

No. I gave it a try. It works in Excel from both the f and c drives.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9954
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.