473,507 Members | 2,472 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

a multi user ACCESS 200 database not allowing more than two users

1 New Member
database not allowing multiusers
--------------------------------------------------------------------------------

Background

An ACCESS database containing two tables and three forms has been installed on the network drive. Using the Tools Menu (Security Sub Menu), five users have been added to the USERS group in the database. The Users group has been assigned OPEN/RUN permission for the database object. The DEFAULT RECORD LOCKING property in the OPTIONS DIALOG BOX, and the FORM Property Record Locks are both set to edited record. The OPEN DATA BASE USING RECORD-LEVEL LOCKING is clicked in the OPTIONS DIALOG BOX.

Ms ACCESS 2000 program is loaded on each workstation which is connected to the network drive.

All the workstation did have the FULL verion of ACCESS 2000; and a runtime version of ACCESS 2000. At installation the runtime version was removed using the Add/Remove feature of WINDOWS Xp.

Problem

The database worked fine when installed, and ran fine for two days.
After a couple of days, it does not allow more than two users to access the system. If more than two persons are in it and another one tries to
open it, it will say 'locked by machine number XXX' and doesn't allow
additional users to use it at the same time.

Question

Is this some type of bug and if so, how can i fix it? or
Did I not activate some feature which I should have to allow multiuser access or
Did I cause some inconsistencies between the OPTION /SECURITY/FORM SETTINGS.

Appreciation

I am still a novice when it comes to ACCESS. Thanks in advance for any help!
Mar 8 '07 #1
2 2461
NeoPa
32,557 Recognized Expert Moderator MVP
I can't see what your problem would be here. But that's not unusual as if you'd known enough to know what information to post, you'd probably have resolved the problem anyway. What you did post was all good stuff, but unfortunately didn't contain any clue (at least for me) as to what your problem may be.
I can only suggest that you think about what may have happened differently after the first two days when it stopped working.
Mar 9 '07 #2
MMcCarthy
14,534 Recognized Expert Moderator MVP
Check these settings in the advanced tab of the options box on all the computers using the database.

Default Open Mode = Shared
Default Record Locking = Edited Record
Mar 10 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
2936
by: Bright | last post by:
Dear All I'm after a multi-User password database so that I can centrally store system passwords and give granular access to individuals based on their own unique authentication (possibly a...
3
9177
by: canigou9 (remove your socks to reply) | last post by:
(cross posted - comp.databases.ms-access, microsoft.public.access) Hello folks - this is my first post here, after a short lurk. I have written an application in Access2002 for a friend's...
2
4829
by: RipTide | last post by:
Background: Using an unsupported/abandoned multi-user multi-database program that uses Access 97 and Jet 3.5. Program itself appears to have been built with PowerBuilder 6.5. Databases reside on...
0
300
by: JMCN | last post by:
hi- i currently have a multi-user database called CP for users to execute a function for a specified account. there are 18 accounts with a 1000 loans each. the code is executed when the user...
5
3676
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....
10
1629
by: Deano | last post by:
Hi, I feel I have a good learning opportunity here. I have been asked to knock up a simple db for managing lettings of rooms and halls. I'm confident about the design but want to make it...
7
2899
by: jsale | last post by:
I'm currently using ASP.NET with VS2003 and SQL Server 2003. The ASP.NET app i have made is running on IIS v6 and consists of a number of pages that allow the user to read information from the...
45
2648
by: Luvin lunch | last post by:
Hi, I'm new to Access and have been asked to develop a simple Access system to replace one that already exists. There are five users of the current Access system and each of the users works off...
1
2000
by: Jaazaniah | last post by:
I'm putting together a form meant purely to lookup values in a consolidated Access db. I've got most everything working with one small hitch - how to make the VB-generated SQL query multi-user...
0
7114
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...
0
7321
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
7034
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7488
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5623
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,...
1
5045
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...
0
4702
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...
0
3179
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
762
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.