Link to home
Create AccountLog in
Avatar of Clive Beaton
Clive BeatonFlag for Australia

asked on

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

I have created a table in the back end database using VBA in the front end.

How do I create a link in the front end to the new table?

Thanks in advance

Clive
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Clive Beaton

ASKER

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