Error 3197

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

Guest

I have an mdb db stored on the server and every employee access this DB from
his PC over the network by openning his/her form, few days ago some emp.
received an error message saying that "the Jet stoped the process becuse
another user is updating the same record" but actulay no one can access other
emp. records due to that each emp. access special areas of data according to
his/her initials in the same table
 
SilverMask said:
I have an mdb db stored on the server and every employee access this DB
from
his PC over the network by openning his/her form, few days ago some emp.
received an error message saying that "the Jet stoped the process becuse
another user is updating the same record" but actulay no one can access
other
emp. records due to that each emp. access special areas of data according
to
his/her initials in the same table
Click to expand...

Is the db split with each user having their own front end?

Keith.
www.keithwilby.com
 
thanks in advance,
each user has a form in the DB and the Whole DB is stored in the server

is that answering you?
 
It sounds, then, like everyone is trying to use the same database, which
isn't a good idea.

You should split the application into a front-end (containing the queries,
forms, reports, macros and modules) and a back-end (containing the tables
and relationships). Only the back-end should be on the server. Each user
should have his/her own copy of the front-end, ideally on his/her hard
drive.
 
can you plz tell how to split it ? and how to let all user refer to the same
db in order to make the changes they did permanent !
 
Back
Top