MS Access database support - update query help. error??

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

update query help. error??

2006-02-20, 8:24 pm

hi,

i;ve created an update query, which WORKS!!,

i've got an update to check a checkbox in a film table,
and i've got another update query to uncheck a checkbox, when a record is
deleted.

but when i go to delete the record, it asks me if i want to run the update
query, then stops and says;

runtime error 3197

The Microsoft Jet Database Engine stopped becasue you and another user are
attempting to change teh same data at teh same time.

how can i overcome this error, as if i close the DB, and then open it again,
it will delete teh record, and update the correct field??

thanx

dev

Sponsored Links