tables linking at runtime

[CHTHOMAS]

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

Regards,

Charley Thomas
chthomas@tebodinme.co.ae

 

[ahmun]

I've been searching the forums all over for a procedure for this... but maybe you can find some help out of this thread: thread700-206511

One of the posts refers to a good book on linking, including some sample code: Access 2000 Developer's Handbook by Litwin, Getz and Gilbert 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 Charley,

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 you are still interested in the relinking table at runtime... I've written a tip. Check out thread700-214835
Earnie Eng - Newbie Access Programmer/DBA
If you are born once, you will die twice.
If you are born twice, you will die once