Trouble Automating Linked Tables

  • Thread starter Thread starter jalexander via AccessMonster.com
  • Start date Start date
J

jalexander via AccessMonster.com

Any ideas on how to automate this laborious procedure which I'm currently
doing manually?

1) Open database
2) Open Linked Table Manager
3) Select All Linked tables
4) Check the Box "Always prompt for new location" & click OK
5) Click on Machine Data Source Tab, choose my Data Source & say OK
-----------------------------------------

The tables are linked ODBC tables via Visual FoxPro dbf.
I set the links up using the newest driver from Microsoft & they work great.
But if a User copies this front-end to their desktop, and tries to open a
form, query or report the database crashes.
The only solution I have found is to go thru the 5 steps above, then copy the
database to their desktop & everything works fine?

I would like to create a MODULE that runs the Steps 1-5 for me, preferrable
on a timer so I can set it to do it after hours.

Thanks in advance for any help!
cw
 
jalexander said:
Any ideas on how to automate this laborious procedure which I'm currently
doing manually?

1) Open database
2) Open Linked Table Manager
3) Select All Linked tables
4) Check the Box "Always prompt for new location" & click OK
5) Click on Machine Data Source Tab, choose my Data Source & say OK
-----------------------------------------

The tables are linked ODBC tables via Visual FoxPro dbf.
I set the links up using the newest driver from Microsoft & they work great.
But if a User copies this front-end to their desktop, and tries to open a
form, query or report the database crashes.
The only solution I have found is to go thru the 5 steps above, then copy the
database to their desktop & everything works fine?

I would like to create a MODULE that runs the Steps 1-5 for me, preferrable
on a timer so I can set it to do it after hours.
Click to expand...


Here are some articles on that subject:
http://www.mvps.org/access/tables/tbl0010.htm
http://www.mvps.org/access/tables/tbl0012.htm
http://www.mvps.org/access/tables/tbl0009.htm
 
Back
Top