Error 3197

K

Kaiti Trimble

Wow, this seems quite the prolific error. Here's my situation: I have a SQL 2005 database with several tables, which are populated by a web app of several pages. That part works fine. My boss uses Access 2007 to look at and manipulate the data (read: delete records), which normally works just fine. However, on this one database, there are 2 tables from which she cannot delete any records. When she tries, she gets this:
"The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time. (Error 3197)" The thing is, nobody else is even looking at the database at the same time! And it only happens on these 2 particular tables, the other ones are fine.

I have tried deleting and recreating the problem tables, but the issue remains. Any suggestions or ideas would be greatly appreciated. Thanks!

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng
 
S

strive4peace

Hi Kaiti,

is the table you are trying to delete from being used in the
RecordSource for another open form (or subform) or report (or subreport)?

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
:) have an awesome day :)
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One note creating multiple tabs when collaborating? 0
Can't send emails on new PC 1
Run-time error '3197' 10
Error 3197 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Error 3197 for just one user 5
FILE LOCKING IN SQL DATABASE - ERROR 3197 0
error 3197,cann't open the database 1

Top