Access 2003 Problem with lock. RRS feed

  • Question

  • 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
    Wednesday, July 10, 2013 2:15 PM