Linking tables at runtime 2

[JimmyN]

Does anyone have a procedure for prompting a user to select a back end to connect to with tables linking at runtime?

 

[rbowes]

Jimmy, take a look at my response to thread 705-93414 in vba modules. Let me know if that helps you with your problem.

Bob

 

[scking]

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

 

[JimmyN]

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.

 

[scking]

I could put it in an Access db container and send it to you if you give me an email address.

Steve King Growth follows a healthy professional curiosity

 

[JimmyN]

Thank you very much. Please send to jneighbour@msn.com

 

[JoeMiller]

Steve could you send a copy to me as well? I'd be interested in seeing it..

Joe Miller
joe.miller@flotech.net

 

[drazeni]

Hi ScKing,

Can I also have a copy (seems your code code could be in demand )

Please email: drazeni@icon.co.za

Thanks.
"All is not as it seems"

 

[judyscofield]

I could really use a copy of this-would you mind sending it to me? jscofield@kc.rr.com.

 

[michiko]

Hi Steve,

possible I could get one too?

lucy_diby@fanniemae.com

 

[hsitz]

Steve -- I've been wanting to do this like this for some time. If you're still sending emails, please put me on the list: hsitz@nwlink.com

Thanks a lot,

Herb

 

[jeremc]

Add me to the list

jeremc@earthlink.net

 

[AndieV]

Please add me to the mailing list for a copy as well.
andrea@spelunking.mb.ca
Thanks
Andie

 

[drazeni]

I don't know about anyone else, but I never got any response from ScKing.

So I don't think anymore posts to this thread will help. "All is not as it seems"

 

[mikehoot]

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!!!!

http://support.microsoft.com/support/kb/articles/Q154/3/97.ASP

 

[huggybear]

Hi there,

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!

Bear

 

[ahmun]

anybody out there can contribute some sample code to this thread? Earnie Eng - Newbie Access Programmer/DBA
If you are born once, you will die twice.
If you are born twice, you will die once

 

[ahmun]

OK...

I searched the net and found the following that might help!

1. Microsoft has the solutions.mdb file for download at their site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bapp2000/html/mdbdownload.asp

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 born once, you will die twice.
If you are born twice, you will die once

 

[ahmun]

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 born once, you will die twice.
If you are born twice, you will die once

 

[wirehead]

See links below:

http://www.mvps.org/access/tables/tbl0012.htm

http://www.mvps.org/access/tables/tbl0009.htm