Code to relink tables doesn't

[David Glass]

I've created a split database, and am using code from the Access 2000
Developer's Handbook to relink the tables to the front end in the event
the backend gets moved.

I've done this many times in the past without issue; it has always
worked seamlessly.

This time however, the code to relink the tables doesn't fire.
Actually, that may not be entirely accurate, it fires but doesn't fire
soon enough.

Normally I put the relink calls in the main form's Open event. This has
worked flawlessly in the past.

In my most recent app, however, before the code can be triggered, I
receive an error about a path not being valid (the path to the backend
on my development machine), and the form doesn't open.

As a test I created an AutoExec macro and put the relink calls in it.
On application launch I get the same error message, but when I dismiss
it the AutoExec macro fires and the tables get relinked. My form does
not open however; I believe the error message causes it to not open (but
that is just a guess).

I'm developing on WinXP Pro, with Access 2003 (Access 2000 format). The
application is being run on Win98 (I think, have to double-check, might
be 2000) with Access 2000.

I'm at a loss as to why this would "suddenly" stop working.

Any assistance would be greatly appreciated.

David Glass

 

[Allen Browne]

Try nominating an *unbound* form as your startup form.

In its Open event, check the links and run any reconnect.
Then open the real startup, and cancel the Form_Open of the fake one, so it
never shows.

 

[David Glass]

Try nominating an *unbound* form as your startup form.

In its Open event, check the links and run any reconnect.
Then open the real startup, and cancel the Form_Open of the fake one, so it
never shows.

That was it. After you mentioned it I realized all my other apps did
indeed start with an unbound form.

Thanks.

David Glass