usslindstrom
asked on
Linked tables (Access) - need to automate via VBScript
Experts,
I have a database that gets copied between two different networks. The catch here, is that I can't share data between the two networks - at all.
The DB in both locations is 100% identical, in structure / layout / etc. The only difference being, the data that's stored in the back end is different.
Of coures, the DB's split into a front end and a back end. And that's where this question comes into play.
Every time I update the Front End of the DB, I need to copy it over to the other network. Since the other network has different network naming conventions / locations / etc - it takes quite a while to manually go in and update all the linked tables to their new location of the BE on the other network.
Is it possible to update the linked tables listing and location of the BE db via VBScript or similar? That way I could put some logic into the DB and have it do it on it's own (via msgbox, command button, etc.)
I've been trying to decifer some of the the codes here:
http://www.visualbasic.happycodings.com/Database_SQL_Stuff/index.html
But haven't had a ton of luck. Any information that can be provided would be greatly appreciated.
I have a database that gets copied between two different networks. The catch here, is that I can't share data between the two networks - at all.
The DB in both locations is 100% identical, in structure / layout / etc. The only difference being, the data that's stored in the back end is different.
Of coures, the DB's split into a front end and a back end. And that's where this question comes into play.
Every time I update the Front End of the DB, I need to copy it over to the other network. Since the other network has different network naming conventions / locations / etc - it takes quite a while to manually go in and update all the linked tables to their new location of the BE on the other network.
Is it possible to update the linked tables listing and location of the BE db via VBScript or similar? That way I could put some logic into the DB and have it do it on it's own (via msgbox, command button, etc.)
I've been trying to decifer some of the the codes here:
http://www.visualbasic.happycodings.com/Database_SQL_Stuff/index.html
But haven't had a ton of luck. Any information that can be provided would be greatly appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The code worked like a champ for the linked tables. I very much appreciate it.