Hello everyone. My question is regarding using myodbc drivers the access 2000 to make bulk changes to the db tables that the install runs off.

Having made a shiny new upgrade to 2.2cvs-mls, I found that my regular methods of changing data in the database worked only on certain tables.

To cut a long story short, in the "product" db, I can not remove, edit or add any products. When I attempt this I get a message saying:

"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the data at the same time".

Very infuriating, I have a worksheet with all the relevant data for 1000 products on it and I can't upload it to the SQL server db!

If anyone has any ideas as to where the "other user" is, I would be most appreciative.

Cheers. www.swrs.net