Questions

MS Access - Locke Records

Tags:
+
0 Votes
Locked

MS Access - Locke Records

computerward
Hi,

Please could someone tell me how to share an Access database on a peer to peer LAN running Windows XP Pro.

i am getting a "record locking" problem when trying to access and update the database from the network?

Many thanks
Graham
  • +
    0 Votes
    shasca

    Is there a stuck .ldb file in the folder where the DB resides? Does someone else have the DB open at the same time?

    +
    0 Votes
    1bn0

    I am not an expert. I have doen a little research because of a similar issue here.

    The current philosohpy from Microsft on sharing an Access database is "splitting the database". The table with the data get put on a server share. The forms and queries are contained in a "front end" that is distributed to the users of the database. Updates to the program (front end) are done on a master front end and deployed to all users.

    http://office.microsoft.com/en-us/access/HP051882971033.aspx

    http://databases.about.com/b/2008/09/28/multiuser-databases-in-microsoft-access.htm

    I do remember setting up a multi user database with access 97 and it wasn't that hard. Just a .mdw? file and a list of users and passwords. But I beleive the database had to be setup to use the security properly.

    +
    0 Votes
    dlovep

    Here are some solutions:

    1. Put the Database sit on a RAIDed Harddrive and change some setting. (Open mode - Shared, Record Locking - No Locks, checked Open database using record-level locking)

    2. Turn the design into Server-Client. (Server side have Tables only and sit in Server, Client side have the interface and sit in User's PC)

    3. Migrate to Web based read/write and reports. (Link your Access to IIS or similiar, use Data Access Page to develop your interface.)

    4. Upgrade to SQL server.

    Cheers,

  • +
    0 Votes
    shasca

    Is there a stuck .ldb file in the folder where the DB resides? Does someone else have the DB open at the same time?

    +
    0 Votes
    1bn0

    I am not an expert. I have doen a little research because of a similar issue here.

    The current philosohpy from Microsft on sharing an Access database is "splitting the database". The table with the data get put on a server share. The forms and queries are contained in a "front end" that is distributed to the users of the database. Updates to the program (front end) are done on a master front end and deployed to all users.

    http://office.microsoft.com/en-us/access/HP051882971033.aspx

    http://databases.about.com/b/2008/09/28/multiuser-databases-in-microsoft-access.htm

    I do remember setting up a multi user database with access 97 and it wasn't that hard. Just a .mdw? file and a list of users and passwords. But I beleive the database had to be setup to use the security properly.

    +
    0 Votes
    dlovep

    Here are some solutions:

    1. Put the Database sit on a RAIDed Harddrive and change some setting. (Open mode - Shared, Record Locking - No Locks, checked Open database using record-level locking)

    2. Turn the design into Server-Client. (Server side have Tables only and sit in Server, Client side have the interface and sit in User's PC)

    3. Migrate to Web based read/write and reports. (Link your Access to IIS or similiar, use Data Access Page to develop your interface.)

    4. Upgrade to SQL server.

    Cheers,