Shared Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a shared database that 9 different users are into, most of the time all at the same time, working with different records. Today we put a security lock on it so only the nine reps can make any changes or even get into the database. Now we have an error message pop up saying the Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. So now one one is able to get in the database. Can you please help!
 
To avoid corruption in a muklti-=user database, it should be split into a
so-called front-end/back-end structure. Each user should have their own copy
of the front-end. Have you done that? If not, google on those terms & you'll
find lots of hits.

HTH,
TC


Rader said:
We have a shared database that 9 different users are into, most of the
Click to expand...
time all at the same time, working with different records. Today we put a
security lock on it so only the nine reps can make any changes or even get
into the database. Now we have an error message pop up saying the Microsoft
Jet database engine stopped the process because you and another user are
attempting to change the same data at the same time. So now one one is
able to get in the database. Can you please help!
 
P.S. That message sometimes shows that the database has become corrupted.

TC


Rader said:
We have a shared database that 9 different users are into, most of the
Click to expand...
time all at the same time, working with different records. Today we put a
security lock on it so only the nine reps can make any changes or even get
into the database. Now we have an error message pop up saying the Microsoft
Jet database engine stopped the process because you and another user are
attempting to change the same data at the same time. So now one one is
able to get in the database. Can you please help!
 
Back
Top