linked tables

[Guest]

This may seem like a very simple question, but I just need to be positive. We
have a shared database on a network drive with many linked tables. If I go
into the linked table manager and link to different tables, this will effect
all users - correct? Thanks!

 

[Douglas J Steele]

If you change the linked tables in a database, then those new linkages
should apply to any user who uses that particular database, with a couple of
caveats.

- If you're linking using drive letters, then the user must have their
drives mapped the same way.
- The user must have access to the linked file

However, you shouldn't have multiple users using the same database. Since
you're asking about linking, it sounds as though you've already split your
application into a front-end (containing the queries, forms, reports, macros
and modules) and a back-end (containing the tables and relations). Each user
should have his/her own copy of the front-end, preferably on their hard
drive.

If you're concerned that each user has the current copy of the front-end,
take a look at the free Auto FE Updater Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm