Error 3197 on Access 2010 apparently with no reasons

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!

Matteo

Apr 26 '12 #1

Subscribe Post Reply

2429

Sweeda

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

Similar topics

Error 3197 on DB - Need Help

by: misschristalee | last post by:

Alright... here's the situation. Because they've crowned me the queen of all that is Access... I had a database (not built by me) from our Insurance group.... currently dead in the water. 1)...

Microsoft Access / VBA

ACC2000 - error 3197 occurs when supplying db password

by: Mike Tickner | last post by:

Can anyone help ? I have a ACC2000 database which has password set. Whenever I now open db I get error 3197 'The Microsoft Jet database engine has stopped the process because you and another...

Microsoft Access / VBA

Error 3197

by: Earl Anderson | last post by:

We have a small (15MB) application which we run over our office network with 4 client stations. Anytime we use the "Find" function (from the main form which is based on a query of the main table)...

Microsoft Access / VBA

Error 3197 but there are no memo fields

by: Jan | last post by:

Hi: I've got the Error 3197 problem ("The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.") in a client...

Microsoft Access / VBA

Compatibility access 2010 to 2007

by: jaad | last post by:

Hello, I have a database that was written in access 2007 on my pc. I wanted to work off site with the database so I uploaded it onto my laptop which is loaded with access 2010 beta. When I...

Microsoft Access / VBA

Access 2010 - Combo Box - Value not Valid...

by: sierra7 | last post by:

It seems Access 2010 is associating an 'input mask' or field type with a combo box when a form is opened, even though there is no Format setting on the control. I have a form which has been...

Microsoft Access / VBA

DBEngine - Access 2003 vs Access 2010

by: Alan Yim | last post by:

Hi folks, My company recently upgraded our Office suite from 2003 to 2010. The problem in particular is with an Access database that was originally designed in Access 2003. The code in question...

Microsoft Access / VBA

Access 2010 -- need Application.SetOption method string to shut off autocorrection

by: Bill Boord | last post by:

I need to be able to shut off the AutoCorrect "feature" within Access 2010 code. I have utilized Application.SetOption with method strings for other startup requirements, but I cannot seem to find a...

Microsoft Access / VBA

What is the equivalent of an ODBCdirect workspace in Access 2010?

by: dsatino | last post by:

I have numerous applications built in Access 2000/2003 that all use ODBCdirect workspaces to access various non-Access databases. Unfortunately, ODBCdirect is 'no longer supported'in Access 2010 and...

Visual Basic 4 / 5 / 6

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General