Error 3197

S

SilverMask

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
 
K

Keith Wilby

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
 
D

Douglas J Steele

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.
 
S

SilverMask

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 !
 
Top