johngordon
Technical User
I have a Access 2000 db with a front and back end.
There are 15 users accessing the back end.
The back end is on a Win 2000 server and front ends are on Win XP Pro workstations.
In Tools > Options > Advanced I have each users front end set to:
Default open mode: Exclusive
Default record locking: Edited record
Open databases using record level locking is checked
The back end is set the same as the front end.
As the users are entering records into the db they are constantly getting record locks, have to exit the db then reopen to clear the locks.
Should the front and back ends be set to open in a shared vice exclusive mode?
What would be the proper setting for the front and back ends given the above situation.
Regards,
John
There are 15 users accessing the back end.
The back end is on a Win 2000 server and front ends are on Win XP Pro workstations.
In Tools > Options > Advanced I have each users front end set to:
Default open mode: Exclusive
Default record locking: Edited record
Open databases using record level locking is checked
The back end is set the same as the front end.
As the users are entering records into the db they are constantly getting record locks, have to exit the db then reopen to clear the locks.
Should the front and back ends be set to open in a shared vice exclusive mode?
What would be the proper setting for the front and back ends given the above situation.
Regards,
John
