ReLinking tables through the use of code

[g28dman]

Credit goes to FoFa for posting this code on this form.

Attached you will find code to relink tables. I manage I am doing to wrong, and need help in order for it to execute correctly. I would appreciate direction.

What I am doing:
Copying the modules over to my unsplit database.
Creating a form called ReLink.
Setting a macro (AutoExec) to open the the form.
On the form's On Open event placing the function =TestIt
Splitting the database.
Verifying by opening FE that connection exists
Moving BE and reopen FE.
All I get is unable to connect the BE message. Form continues to open.

Thanks for insight.

[g28dman]

OK...Update!

I got this working with the following exception

When FE first opens it asks to link BE. On 2nd open it does not open the open file window as long as the FE and BE are in the same directory.

When I change the BE to a different directory it opens the open file window each at start up, does it not save the info the first time? Is it possible to do this.

Thanks