record, page, table locking

Hello,
I have set up a sql server database with three tables, and I am using MS Acc
ess as the front end for user view, inserts, and updates.
The transaction properties for the database are set as follows:
lock_timeout = 1800
Session isolation level = serializable
access mode is multiuser.
Recently, one person had the MS Access database open and made deletions with
out any problem, closed the database and then opened it later to delete more
records from a table but recieved this message "the microsoft jet db engine
stopped the process becaus
e you and another user are attempting to change the same data at the same ti
me." error 2197. but they are the only one's who have the db open. Would any
one be able to tell me which setting I have misconfigured?
Thanks,
ChiekoThis is an Access issue. I suggest you post the question to an Access group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Chieko Kuroda" <anonymous@.discussions.microsoft.com> wrote in message
news:22D5A1D3-6B23-4E53-9809-F13CA9C97A20@.microsoft.com...
> Hello,
> I have set up a sql server database with three tables, and I am using MS
Access as the front end for user view, inserts, and updates.
> The transaction properties for the database are set as follows:
> lock_timeout = 1800
> Session isolation level = serializable
> access mode is multiuser.
> Recently, one person had the MS Access database open and made deletions
without any problem, closed the database and then opened it later to delete
more records from a table but recieved this message "the microsoft jet db
engine stopped the process because you and another user are attempting to
change the same data at the same time." error 2197. but they are the only
one's who have the db open. Would anyone be able to tell me which setting I
have misconfigured?
> Thanks,
> Chieko
>