473,840 Members | 1,425 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

multiple user access on shared network drive possible?

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
1 4376
kr***@hotmail.c om (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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
1579
by: AGoodSpellr | last post by:
Is it possible to use Visual Studio to create ASP.NET projects on a web server, without giving the various people that will be doing this full administrator privliges? Each user will need to have independent folders that they can modify (ie, one user cannot change the contents of another user's folder). Access to the server must be strictly limited for each user (preferably to just adding/removing ASP.NET projects). Having a similar...
0
1276
by: MikeL | last post by:
I am using Access 2K and have created a simple data access page which only works properly when it is run from the local C drive. The data file that is being accessed is held on a shared network drive, and the data access page works for anyone on our domain, but only if the htm file is run from the local c drive. If I attempt to run it from either a network shared drive or from our intranet server, the page loads and displays static data...
5
3701
by: premmehrotra | last post by:
I currently have a multi-user access database which is put on a shared drive L: on a Windows Servers. Entire database is one file premdb.mdb. Users access this database from their laptops. Following problems occur: 1. Access is way too slow in WAN environment. Server is located in New Jersey and users are in California and Puerto Rico. 2. Database often becomes corrupt 3. When one user updates some data in the database, other users...
2
2652
by: flat_ross | last post by:
Hi, I am in a shop where developers are required to work off of a network share. This is so that code is backed up nightly. So I am testing running an ASP.NET Web application with a Class assembly all on a shared drive. I have the solution working perfectly. However, I have run into a hiccup. In order to map IIS Virtual Dir to a network drive, you need
11
2330
by: ASP.NET User | last post by:
Hi I am in a shop where developers are required to work off of a networ share. This is so that code and other documentation is backed up nightly. This is outside the realm of Visual SourceSafe which we also use for code control. The network drive is used as the working folder. This is a configuration this shop has used for 6 years and I do not see it changing any time soon So I am testing running an ASP.NET Web application with a Clas...
12
3106
by: Ron Weldy | last post by:
I have a test server runinng 2003/IIS 6 with a mixture of asp and asp.net files. On my workstation I have a share set up to the folder where the web files reside. I am just doing quick and dirty asp editing (like I used to be able to do with 2K/IIS5) where I use VS.NET, open an asp file, make changes, save and refresh my browser. Problem is that I get an Access is Denied error when I try to save the file and then the file gets wiped on...
3
2417
by: Henners | last post by:
Hi There We are migrating our network file system from Novell to Windows. (There are pros and cons).... In this process, we have noticed that a good bunch of user created access databases have modules or macro code that points to: \\NETWARESERVER\share\data
17
3928
by: teddysnips | last post by:
One of my clients has asked me to make a change to one of their Access applications. The application is a Front End/Back End standard app. I didn't develop it, but looking at it tells me that it was done entirely using the Wizards. There is no log-in procedure. They want to amend it so that only one person can be logged in at any one time. So, if Joe Bloggs tries to open the application, and Fred Jones has already connected, Joe...
1
2442
by: Technicalprob | last post by:
Problem: I designed a small access database and created tables and relationship between them. The database works fine and have no problem. I have stored the database in My Documents on my hard disk but the moment I put it in a folder on the shared network it does not work. The database will open fine 3 or 4 times but 5th time I try to open it will give an error message. Error message: Microsoft Office has detected that this database is in...
0
9856
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9698
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9436
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7836
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7022
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5684
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5872
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4071
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3136
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.