Linking

[JC]

We have a few databases at work that I would like to give
users access to via the one database and screen, is it
possible to set up a database that links to these other 3
given users access to all the database but through the one
screen. Thanks

 

[Nikos Yannacopoulos]

Yes, it is. Create a new, blank database and then link to the tables in the
other three (File > Get External Data > Link Tables). That way your new
database (front end to your users) treats the tables in the original three
..mdb's (back ends) as local tables, as far as reading, canging and adding
data goes. So, you can add all your queries, forms, reports, macros and code
to the front end and distribute that to your users. Just make sure the back
ends are in public network forlders, and that all the users have the same
drive mapping to them (unless you use UNC addressing, which is a lot more
robust).
Take some time to browse through the multiuser group up front, it will prove
very helpful, and potentially save you a lot of frustration.

HTH,
Nikos