Network linking issue

[motleyjew]

I have been having problems with one of our network drives going down every day. When this happens, my shared access databases are useless untill the network problem can be solved.
I have a my backend split on the network and all user have a frontend stored on their desktop. I decided to change the location of the database to a shared drive that has not been crashing. I went into Linked mangager and changed all my linked tables to the new location and then redistributed the frontend with the new links.
Today when the OLD network drive went down, it took down my database with the NEW links. Is there somewhere else that I need to change the link to the database beside the linked table manager? I was able to open all of the links but when I tried to open up a form, access hung up with just a white screen until the old network came back up.
Thanks
Gregg

 

[boblarson]

Do you have any tables hidden? If you do and didn't go set the SHOW HIDDEN when you used linked table manager, it won't relink those unless they are able to be seen.

 

[motleyjew]

Hi Bob. There are no hidden tables in this database. I do have "show hidden" checked off just in case but that doesn't seem to be the issue. All of the other objects in the frontend are non linked tables.
This datbase was made in access 2003 in 2000 format and I is now being used in access 2007. I was wondering if maybe there is another place a link could be hiding.

 

[boblarson]

The only other thing I can think of is if you had some code which opened a connection to the location instead of relying on a linked table.

Perhaps if you are able to use the Free V-TOOLS Total Deep Search, you can find where it is referencing the old server.

 

[motleyjew]

Unfortunatly I don't have admin rights so I can't install V-tools. I'll search my code to see if there was something I may have forgotten about that referenced the old tables. Thanks again for the tips Bob.

Gregg

 

[motleyjew]

I think I found the issue and you are correct Bob. I have a form that runs in the background on open that has a timer on it that checks to make sure the network is still availble. This is where I had the link to the network that was having problems. Thanks again for your help.
Gregg

 

[boblarson]

Cool, glad you found it.