473,626 Members | 3,294 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Error 3197 on Access 2010 apparently with no reasons

12 New Member
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
1 2437
Sweeda
12 New Member
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

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

Similar topics

1
4209
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) Both front and back end of this db is in this file (not my first choice of roads to take...) 2) The problem began when the network guru tried to move it FROM a fileserver TO a citrix server box.
1
1529
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 user are attempting to change the same data at the same time' Why is does this occur when the correct password is submitted on accessing the database, and more critically what can I do to rectify the situation.
2
12161
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) or run a query or try to "Copy" - "Paste" in the database window on the main table of the application, we get the following error message with the accompanying 'Help' message: " The Microsoft Jet database engine stopped the process because you...
12
2666
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 database. It started appearing about a month ago and has gotten worse and worse. The responses I saw when I searched on this topic talk about corruption in a memo or OLE field, but there are none of those in this database. I took a copy of the...
5
12415
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 finished working with the database and return it to my pc(which has access 2007) I can't get it open because Access say that the file is not the right format. Does anyone have a way to work around this compatibility problem? So you know I...
2
6703
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 running OK for years in Access 2003; it adds an item selected from an inventory listing to either an existing Sales Order or Purchase Order. For historic reasons Purchase orders are alphanumeric and Sales orders are numeric (long integer). The RowSource...
1
5246
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 used work in 2003 (see below code). Private Sub engSave_Click() Dim strSql3 As String 'Archive order number and cost data for engine.
2
7315
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 correct method string to turn off the text replace "feature." I am not talking about the "Track Name AutoCorrect Info" method, but rather the method that corresponds to the checkbox if one were to enter Access 2010 and click File, Options,...
1
8481
dsatino
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 when my associates get new PC's, the applications fail. The error message says to switch from DAO to ADO. This is a little curious since ADO is dying/dead as well. I'm hoping someone can add a little insight/best practice to my situation.
0
8262
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8701
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
6122
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5571
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4090
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4196
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2623
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1807
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1507
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.