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
- Follow via:
- RSS
- Email Alert
Question
0
Votes
Answers (2)
0
Votes
.LDB
Is there a stuck .ldb file in the folder where the DB resides? Does someone else have the DB open at the same time?
16th Oct 2008
0
Votes
There is more to it than just sharing the file.
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.
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.
16th Oct 2008
Replies
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,
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,
dlovep@...
3rd Nov 2008
