odbc: can not change products table in access

[Guest]

From Windows XP we have made an odbc connection to the MySQl database that runs OSCommerce.

It work perfectly with Microsoft access and we can change every value in every connected table.

Accept for PRODUCTS (The most important table !!).

Access always reply's that the record is locked by another user.

Does anyone know this problem ?

[Guest]

does anyone know of this problem?

or maybe someone who also has made a odbc connection with access, and who can update prices from access, can he post how he has made his connection?

[wizardsandwars]

A coyuple of quick point to make.

 

1.) ODBC is by far the LEAST efficient way of administering you database. Whenever possible, you should always use native drivers.

 

2.) MS Access is probalby the LEAST reliable of all DB administration tools. However, if you *must* use MS Access, and you'd like to find out why you are bing locked, try running a 'show processlist' command in the query window, and see if you can find a process running against that table that has obtained the block. It's been my experience that sometimes using the 'link tables' in MSAccess will cause some function to 'block itself'. In otherwords, it attempts to update and select the same rows at the same time, resulting in a deadlock, where neither process can complete successfully.