How do I create a link from the front end to a table in the back end.

I don't know if this is important but the table only exists in the back end.

With transferdatabase:

1. Does the table have to exist in the front end?
2. Where do I specify the password for the back end?

If so, you may need the method described here:

Docmd.TransferDatabase with a password-protected database

Ignore my last question.  Problem solved.  Thanks to you both.

Clive

Hi Clive,

If you keep a persistent link to that table you created, you also need to relink when the location of the back-end database changes.  You're welcome to use our free J Street Access Relinker on our J Street Downloads page.  It's a lot nicer than the Linked Table Manager.

http://www.JStreetTech.com/downloads

It's some code that you simply copy into your front-end application.  It handles multiple Access back-end databases, ignores non-Access tables, and can automatically and silently relink to back-end databases in the same folder as the application (handy for work databases or single-user scenarios).  There's a ReadMe table with instructions.

Cheers,
Armen

i am using J Street Access Relinker and it works wonder...
Thanks

Thanks Kamlesh!  Glad you like it.  :)

Hi Armen,

Thanks for that.  I wish I had it years ago.  It would have made life so much easier.

Clive