Change Linked Table links on run time?

[ET]

Hello friends,

did somebody try this, is it possible to change Linked Table's links on
run time?

Lets say, database in mde format opens, and you need to change location
of the datafiles for linked tables.
You click a button on a update form, and explorer window pops up,
allowing you to specify location of the file.
Thank you!

[Allen Browne]

There's an example of how to do that in the Refresh Links module in
Microsoft's sample database named solutions.mdb. You can download it from:
http://msdn.microsoft.com/library/of...dbdownload.htm

Essentially, it's just a matter of looping through the TableDefs to set the
Connect property, but you need an API call to let the user locate the back
end with the FileOpen dialog.

If you have secured the database, you need to log in with adequate privliges
to set the Connect property.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ET" <ve****@yahoo.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

Hello friends,

did somebody try this, is it possible to change Linked Table's links on
run time?

Lets say, database in mde format opens, and you need to change location
of the datafiles for linked tables.
You click a button on a update form, and explorer window pops up,
allowing you to specify location of the file.
Thank you!