Transfer Database not working

[Bill (Unique as my name)]

The transfer database command
does not work in macro.
It doesn't work in code.
Will someone help me please,
before I get too old.

 

[Jonathan West]

The transfer database command
does not work in macro.
It doesn't work in code.
Will someone help me please,
before I get too old.

You may get older yet
Before our help can reach you
We need to see the macro
So that we can teach you


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[Jean-Guy Marcil]

Jonathan West was telling us:
Jonathan West nous racontait que :

You may get older yet
Before our help can reach you
We need to see the macro
So that we can teach you

LOL
We are almost in limerick or Haiku land!

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Bill (Unique as my name)]

I have to run to program
to fill my head with light.
Tomorrow I shall post the code
so all may see my plight.

 

[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.

 

[Jonathan West]

Hi Bill

This group deals with VBA in Word. For questions about Access, the experts
can be found at one of the groups whose name starts with
microsoft.public.access. Perhaps microsoft.public.access.modulesdaovba is
the best group for the purpose.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[Bill (Unique as my name)]

Oops. Sorry. I'm heading over to the right place.

Thanks for the tip.