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

Error 3197 on Access 2010 apparently with no reasons

P: 12
Hi guys, as you read in the title, I've got problems with more than one record in a table:

On opening the form that displays the field it appears the error 3197
"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time"

I've lost data of those fields and it looks like there's no way to get them back.

Apart from recovering these data, I'm afraid that this can happen again on other records, with loss of many data.

I am pretty sure that the real problem IS NOT the simoultaneous use by more than one user, because at the moment only one person is using it.

Details: access 2010 accdb, splitted, used by 2010 accde front-ends and accdb (compatible with 2007) front-ends. .accdb is on a server, front-ends are in lan.

many thanks if you can help me!

Apr 26 '12 #1
Share this Question
Share on Google+
1 Reply

P: 12
I correct myself, i'm SURE that the problem is not the simultaneous work on the same record, I tried it, and it works perfectly
Apr 26 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.