How to re-link tables

[bishop0071]

I have a database with the frontend and backend on same network. Now when I have to do changes to it I take a copy of the frontend or backend home and re-link the table on my computer.

Now when I finish it all I want to be able to do is email the frontend or backend to someone without having to drive out there and this computer only has access runtime installed. So I have to go up there, bring my laptop, access their server, and link the database on my laptop, then take the files and drop it on their computer

I would like it when I email them the files an option could pop up to re-link the files since they are just using access runtime.

Thank you

 

[RuralGuy]

Here's an option: http://allenbrowne.com/ser-13.html

 

[bishop0071]

Thank you! That is exactly what I am looking for. One more question, where do I put this code?

Thanks again

 

[RuralGuy]

I use the AutoExec macro to load an invisible form and then call code in the OnLoad event of the invisible form. The code itself goes in a standard module.

 

[bishop0071]

I do not know what I am doing wrong. I created an AutoExec macro to open up the form. I put the code in the Onload event and nothing is running

 

[RuralGuy]

What version of Access are you using? Have you set a Trusted Location yet?

 

[bishop0071]

access 2007. no have not.

 

[RuralGuy]

This link should help: http://www.btabdevelopment.com/ts/default.aspx?PageId=13