Linking Tables

[AmyLynnHill]

I have a DB with Linked Tables to a Datawarehouse. Each day I have to re link the tables for some reason. (IT may have implemented something). Does anyone know of a method/object that would keep the tables linked?

 

[boblarson]

Does the access database stay open all of the time? Or do you close it every day. If it remained open I could see where the data warehouse is deleting their tables and recreating them could cause something like that.

 

[AmyLynnHill]

I does not remain open. I think our IT department created a way to disconnect ALL of the ACCESS db utilizing Datawarehouse. They are in the middle of converting to a reporting software and will be disabling business users to utilize the datawarehouse tables. A programmer here told me to look at VB code and write something to re link the tables when I open the application.

 

[boblarson]

It really shouldn't be disconnecting unless they are changing the login information each time. Because, when Access is closed there are no links to the other database. When you open it up it looks for those tables and automatically links them. If the information that Access has for those tables is not the same for the current tables then it says they don't exist and won't relink. I'm not sure what they are doing to cause the change, but relinking through code is worth a shot, but it may not help.

Check this post to see if this helps:

http://www.access-programmers.co.uk/forums/showthread.php?t=127301