URGENT Trouble with “… attempting to change the same data ...”
in [General]
|
Prev: generate_series in ms access
Next: Linked Tables
From: Roberto on 4 May 2010 13:31 This is the third time I try ti post this question. I hope finally can be readed for somebody. I have an Access 2007 Front End linked with a ODBC driver to a MySQL database in a multiuser environment. I have a problem with a form that shows me the values of a particular table. Until a couple of days ago, when any users deleted a record, it works perfectly. But since yesterday, when anyone tries to delete any record, Access shows a dialog box with the following message: “The Microsoft Office Access database engine stopped the process because you and another user are attempting to change the same data at the same time.” It happens no matter if the record that I was trying to delete is a new record that I am sure that is not been edited by any other person. ¿Can you help me?
From: golfinray on 4 May 2010 13:49 I can just tell you from my experience anytime I have problems with ODBC it has been ODBC. Now if I have a problem I just delete and re-create the ODBC driver. If that doesn't do it I delete and reload the ODBC driver in the server. Then, when you go into Admin and check your ODBC, it has a test function. Test it first, but don't completely trust the test. Also look for the path. Sometimes the path to the server gets out of whack. -- Milton Purdy ACCESS State of Arkansas "Roberto" wrote: > This is the third time I try ti post this question. I hope finally can be > readed for somebody. > > > > I have an Access 2007 Front End linked with a ODBC driver to a MySQL > database in a multiuser environment. I have a problem with a form that shows > me the values of a particular table. > > Until a couple of days ago, when any users deleted a record, it works > perfectly. But since yesterday, when anyone tries to delete any record, > Access shows a dialog box with the following message: > > “The Microsoft Office Access database engine stopped the process because you > and another user are attempting to change the same data at the same time.” > > It happens no matter if the record that I was trying to delete is a new > record that I am sure that is not been edited by any other person. > > ¿Can you help me? > >
From: Roberto on 4 May 2010 16:03 Thanks again golfinray, I have just read the last replay that you wrote to my original question. I post 3 times the same question because I couldn´t found them published in the groups, until now. Anyway, I want to tell you that I don´t have any ODBC installed in the server. I installed the "mysql-connector-odbc-5.1.6-win32.msi" on every PC/Laptop that runs the Access front end and i create a dsn file that is installed in the "C:\Program Files\Common Files\ODBC\Data Sources" on each of them. These dsn file have the next statements: [ODBC] DRIVER=MySQL ODBC 5.1 Driver SERVER=172.26.0.23 PORT=3306 USER=xxxxxxx PASSWORD=yyyyyy DATABASE=iris and when I link the tables, all of them uses this information, becuase I use this file accordind to the process to link them. I don´t think that the dsn is corrupt because the trouble of deleting records, happens on any pc, not only in mine. "golfinray" wrote: > I can just tell you from my experience anytime I have problems with ODBC it > has been ODBC. Now if I have a problem I just delete and re-create the ODBC > driver. If that doesn't do it I delete and reload the ODBC driver in the > server. Then, when you go into Admin and check your ODBC, it has a test > function. Test it first, but don't completely trust the test. Also look for > the path. Sometimes the path to the server gets out of whack. > -- > Milton Purdy > ACCESS > State of Arkansas > > > "Roberto" wrote: > > > This is the third time I try ti post this question. I hope finally can be > > readed for somebody. > > > > > > > > I have an Access 2007 Front End linked with a ODBC driver to a MySQL > > database in a multiuser environment. I have a problem with a form that shows > > me the values of a particular table. > > > > Until a couple of days ago, when any users deleted a record, it works > > perfectly. But since yesterday, when anyone tries to delete any record, > > Access shows a dialog box with the following message: > > > > “The Microsoft Office Access database engine stopped the process because you > > and another user are attempting to change the same data at the same time.” > > > > It happens no matter if the record that I was trying to delete is a new > > record that I am sure that is not been edited by any other person. > > > > ¿Can you help me? > > > >
From: Roberto on 4 May 2010 20:09 Although I am not sure about the ODBC, I have just desinstalled the ODBC connector y deleted the dsn file. Then I reinstalled the ODBC conector and made a new dsn file in my laptop. After that, I delete all the linked tables in my Access FE, and linked again every table with the new dsn file, but the trouble still persist. "Roberto" wrote: > Thanks again golfinray, > > > I have just read the last replay that you wrote to my original question. I > post 3 times the same question because I couldn´t found them published in the > groups, until now. > > > Anyway, I want to tell you that I don´t have any ODBC installed in the > server. I installed the "mysql-connector-odbc-5.1.6-win32.msi" on every > PC/Laptop that runs the Access front end and i create a dsn file that is > installed in the "C:\Program Files\Common Files\ODBC\Data Sources" on each of > them. > > These dsn file have the next statements: > > [ODBC] > DRIVER=MySQL ODBC 5.1 Driver > SERVER=172.26.0.23 > PORT=3306 > USER=xxxxxxx > PASSWORD=yyyyyy > DATABASE=iris > > and when I link the tables, all of them uses this information, becuase I use > this file accordind to the process to link them. > > I don´t think that the dsn is corrupt because the trouble of deleting > records, happens on any pc, not only in mine. > > > > > > > > > > "golfinray" wrote: > > > I can just tell you from my experience anytime I have problems with ODBC it > > has been ODBC. Now if I have a problem I just delete and re-create the ODBC > > driver. If that doesn't do it I delete and reload the ODBC driver in the > > server. Then, when you go into Admin and check your ODBC, it has a test > > function. Test it first, but don't completely trust the test. Also look for > > the path. Sometimes the path to the server gets out of whack. > > -- > > Milton Purdy > > ACCESS > > State of Arkansas > > > > > > "Roberto" wrote: > > > > > This is the third time I try ti post this question. I hope finally can be > > > readed for somebody. > > > > > > > > > > > > I have an Access 2007 Front End linked with a ODBC driver to a MySQL > > > database in a multiuser environment. I have a problem with a form that shows > > > me the values of a particular table. > > > > > > Until a couple of days ago, when any users deleted a record, it works > > > perfectly. But since yesterday, when anyone tries to delete any record, > > > Access shows a dialog box with the following message: > > > > > > “The Microsoft Office Access database engine stopped the process because you > > > and another user are attempting to change the same data at the same time.” > > > > > > It happens no matter if the record that I was trying to delete is a new > > > record that I am sure that is not been edited by any other person. > > > > > > ¿Can you help me? > > > > > >
From: a a r o n . k e m p f on 5 May 2010 08:23
wow.. welcome to the world of database locking Access (Jet) doesn't give you the tools you need to fix a problem like this moving to SQL Server / Access Data Projects allows you to use QueryHints THIS CAN RUN EVEN WHEN ANOTHER USER HAS A TABLE LOCK Select * From employees WITH (NOLOCK) Where firstname = 'Aaron' On May 4, 10:31 am, Roberto <robe...(a)hotmail.com.ar> wrote: > This is the third time I try ti post this question. I hope finally can be > readed for somebody. > > I have an Access 2007 Front End linked with a ODBC driver to a MySQL > database in a multiuser environment. I have a problem with a form that shows > me the values of a particular table. > > Until a couple of days ago, when any users deleted a record, it works > perfectly. But since yesterday, when anyone tries to delete any record, > Access shows a dialog box with the following message: > > The Microsoft Office Access database engine stopped the process because you > and another user are attempting to change the same data at the same time. > > It happens no matter if the record that I was trying to delete is a new > record that I am sure that is not been edited by any other person. > > ¿Can you help me? |