Problem with lock.

[vagelisr]

Good evening to all.

I would like to ask
I have a database in Access 2003 that works without any problem for over 3 years.
I tried to break a copy of the database and to convey all the tables (without the relations between them) in mysql and access have only the link of the tables.

The encounter problem is this.
When the tables is in access when a user try to change something in a record access automatically lock this record and no one can make any further changes.
Now where the table is in mysql why when someone makes changes the record did not lock for the other users.

We using Access 2003 with SP3 and Windows XP with SP3

 

[SOS]

Go to Tools > OPTIONS and then to the tab (can't remember which one) that has the DEFAULT RECORD LOCKING radio buttons and the Open Databases By Using Record-Level Locking.

Make sure that NO LOCKS is selected on the first and the checkbox is checked.