Our database is split : iftm and iftm_princip. The data (iftm_princip) are
in the server and each user has the codes (iftm).
I am thinking to put the codes (iftm) too in the server and make a shortcut
of the codes (iftm) in each user.
What would be the best?
Thank you.
> Our database is split : iftm and iftm_princip. The data (iftm_princip) are
> in the server and each user has the codes (iftm).
>
> I am thinking to put the codes (iftm) too in the server and make a
> shortcut of the codes (iftm) in each user.
Having multiple users logged in to the same front-end or monolithic database
significantly increases the chances of database corruption. I advise having
a copy of the front-end (queries, forms, reports, macros, and modules) on
each user's machine.
If you fear keeping these in synch would be a problem, google on the
archives of this newsgroup and of the USENET newsgroup
comp.databases.ms-access. You'll also find an overview presentation on
_Using Access in a Multiuser Environment_ at http://appdevissues.tripod.com
, an article on "versioning" at http://accdevel.tripod.com, lots of good
information and links at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm (including his Auto Front End
Updater), and more information at MVP Jeff Conrad's site,
http://home.bendbroadband.com/conradsystems/accessjunkie/.
Larry Linson
Microsoft Access MVP
Telesphore - 03 Jun 2006 15:17 GMT
Thank you Larry.
Telesphore