Multiple users opening queries on shared network

  • Thread starter Thread starter bcaron
  • Start date Start date
B

bcaron

I have a database saved on a network. When I open a query, I get the correct
results. When another user on the network opens the same query, this user
gets different (and incorrect) results. Only this 1 user is getting incorrect
results, which leads me to believe it is a setting within that user's version
of Access. Also, even though this database is shared and is able to be opened
by multiple users at once, if above user (who gets the incorrect results) has
the database open, no other users are able to open it.
 
Possibly because this user doesn't have the exact same version of Windows
and of Access, including any service packs.

In a multi-users environment, you should split the application into a
frontend and a backend and each user should have his/her very own copy of
the frontend, usually but not necessarily on his/her local hard drive (in
order to diminush unecessary network communications for the forms, modules,
reports and the resulting compiled binaries.

Also, when distributing this frontend, you should make sure to distribute an
uncompiled version of the file or - if you are copying it from another
user - to decompile it on the target machine before using it.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)
 
Back
Top