On Tue, 7 Jul 2009 07:19:02 -0700, JK jasonk at necoffeeco dot com
wrote:

Rather than trying to get the Law Tracks Reconnect/AttachAgain examples to
work, maybe someone has another way to check for the ability to connect to
the backend during the login process and if the backend is not available
display an error?

I'm sure John Viescas's code will work when you figure out what's
going on. But if you want an alternative for automatic Access table
relinking, you're welcome to incorporate our free J Street Access
Relinker at:
http://www.jstreettech.com/downloads

It handles multiple Access back-end databases, ignores ODBC linked
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.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com