By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,490 Members | 1,753 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,490 IT Pros & Developers. It's quick & easy.

update query help. error??

P: n/a
DP
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
Feb 20 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.