We have a online OSC shop, and we use MS access for stock control on a local computer. We have the ability to update the stock from our OSC DB to the Access DB threw an ODBC connection. But we are having problem to update the OSC DB form Access threw our ODBC connection. We get error code: 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.
We have tried to test this on an offline Database with the same result.
Access 2003, OSCommerce v2.2 RC2a with Mysql version 4.1.22-standard and MySQL ODBC 5.1 Driver.
10 freelancers are bidding on average $111 for this job
I am an IT professional with 10 yrs experience with Ms-Access & MySQL. I have completed many projects on GAF in Ms-Access skill. I will provide quick & professional service.