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
>

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 can happen with a few different scenarios. Basically,
ODBC will use a timestamp to determine if the record has
been updated. If there is no timestamp column, it compares
all column values to see if the record has been updated.
Some situations can cause Access to become "confused" as to
whether the record has been update - such as having float
data types. Try adding a timestamp column to the SQL table
and see if the fixes the problem. There should be some
Access knowledge base articles on this subject that you may
want to search for.
-Sue
On Thu, 18 Mar 2004 11:21:05 -0800, "chieko Kuroda"
<anonymous@.discussions.microsoft.com> wrote:

>Hello,
>I have set up a sql server database with three tables, and I am using MS Ac
cess 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 be
cau
se you and another user are attempting to change the same data at the same time." error 219
7. 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
>
>
>