Automatic Table Link Refresh

[Kevin]

Is the a way to automtically refresh links to remote tables. I want to be
able to refresh the links on a database setup with remote tables. I am
developing a database that has links to Outlook and at least one other access
database. When I put this application onto a new computer, I want to be able
to refresh these links so there are no problems. If I could do that without
user inpute that would be even better.

Any help will be greatly appreciated!

Kevin

 

['69 Camaro]

Hi, Kevin.

Please see the article, "Relink Access tables from code," on the following
Web page:

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

You can use the suggested prompt for user input to supply the path and file
name for the linked tables, or your code can check a table in the database
where this path and file name are stored for the remote site's network,
thereby leaving the user out of the loop.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)