Our app verifies the links on opening the database. If any are not valid the user is prompted with a form which opens and states those which were not found and asking if they want to relink. A browse button on the form allows the user to user Windows type controls to find the database and put the full address in the table link connection. Or the user can select from a recent list of back ends using a combo box. Works very well.
Steve King Growth follows a healthy professional curiosity
This is exactly what I need to do scking. Can you give me any idea how you achieve it? I am comfortable with Windows type controls, it's the actual linking of the back end in Access that I'm not sure of. I'd be very grateful.
Here is a link to a Knowledge Base example of how to manage linked tables in Access. I have used this to great effect in a few of my apps.
It contains functions to check links on startup, re-link if neccessary using windows common dialog, but if the links are correct will jump straight into app. There is no function to change the location of the links if they are correct, apart from renaming the _be and tricking it into prompting for a new path. Works well though!!!!
I just saw this thread and maybe everyone has found a way to manage linked tables by now. But, if not, I would suggest you get a copy of "Access 2000 Developer's Handbook" by Litwin, Getz and Gilbert. This is a two-volume set and the subject of splitting databases if covered in Volume 2. Each volume includes a cd with a lot of code you can use (including routines to fix links at runtime), just give them credit when you do.
These guys cover almost every aspect of Access programming and they have excellent chops.
I hope this doesn't violate any of the commercialism rules here at Tek-Tips. If it does, I take it all back!
anybody out there can contribute some sample code to this thread? Earnie Eng - Newbie Access Programmer/DBA If you are bornonce, you will dietwice. If you are borntwice, you will dieonce
2. Inside the solutions.mdb file, there is a module called "modRefreshTableLinks" This module shows how to do re-linking of tables applied to the Northwind Sample Database that comes with Access.
Happy code deciphering! ;-) Earnie Eng - Newbie Access Programmer/DBA If you are bornonce, you will dietwice. If you are borntwice, you will dieonce
If anybody wants to see a solution to re-linking tables at runtime, see the tip I wrote. thread700-214835
lemme know if there are any errors... it does work fine on my application, tho.
Earnie Eng - Newbie Access Programmer/DBA If you are bornonce, you will dietwice. If you are borntwice, you will dieonce
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.