By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,949 Members | 2,043 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,949 IT Pros & Developers. It's quick & easy.

multiple user access on shared network drive possible?

P: n/a
Are there any problems with multiple user access to the same Access
database on a shared network drive? I have 'shared' chosen for
'default open mode'. As for the record locking properties, I selected
'edited record' for default record locking; also, 'Open databases
using record-level locking' is checked.

We seemed to experience difficulties in this office - just once so
far, I think - with more than one user accessing the database on a
network drive. However, I'm not sure if this was a one-time network
glitch or might turn out to be a recurrent problem.

Also, I saw in posts such as
http://dbforums.com/arch/106/2003/8/851472 that users have to be in
the same security .mdw file for record locking to work. I'm not sure
exactly what an .mdw file is, but that seems to be a network
administration/server configuration user involving user groups.
(However, that may be a different issue since that's a situation where
multiple users can access the database when they supposedly are unable
to, given the database record-locking properties. We're experiencing a
different issue: the record-locking properties are set for multiple
users to access the database, but we seem to be experiencing
difficulties with more than one user accessing the database at the
same time.)
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
kr***@hotmail.com (intl04) wrote:
Are there any problems with multiple user access to the same Access
database on a shared network drive? <snip>
Yes. If multiple users access the same mdb file then you will eventually
encounter corruption of data. Split the mdb into Front and Back Ends - that
is, have all the data tables in one mdb (Back end, located on the server)
and all other objects in the Front End mdb, one on each user's local drive.
The FE mdb contains linked tables, the source of which are your BE tables.
We seemed to experience difficulties in this office - just once so
far, I think - with more than one user accessing the database on a
network drive. However, I'm not sure if this was a one-time network
glitch or might turn out to be a recurrent problem.

Also, I saw in posts such as
http://dbforums.com/arch/106/2003/8/851472 that users have to be in
the same security .mdw file for record locking to work. <snip>


Record locking is achieved using a temporary "ldb" file which is created
and stored next to your BE data tables whenever the application is opened.
All users of the app will use this file.

HTH - Keith.
www.keithwilby.org.uk

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.