Re: access to Access
- From: Bob Alston <tulsaalstonsNOSPAM@xxxxxxx>
- Date: Thu, 26 Jan 2006 19:27:26 -0600
Br@dley wrote:
Just to be clear multiple people SHOULD be able to access a single Access database simultaneously. If on your network more than one person can access the database but only one at a time, then the problem is likely that people are opening the database in EXCLUSIVE rather than shared mode.Mike Kelliher wrote:
We use MS access 2000 at work and few people know how to work it including me. We are using it on a network and more than one person is trying to access it at once. Needless to say this isn't working as one has to log out first before another can enter data. Is there an easy way around this? Or a complicated way, actually I'll take anyway. Thanks Mike We have just started this database so any changes would be better done sooner.
It's highly recommended to have the database split with the data on the shared network drive and a copy of the frontend (forms/reports/etc) on each PC.
You'll still get issues if people try to edit the same record for example.
Also, you must make sure each user has permission to create new files on the network dive/folder where the MDB is located as Access dynamically creates an LDB file for record locking. If they can't create this file then Access reverts to single-user only.
Bob .
- References:
- access to Access
- From: Mike Kelliher
- Re: access to Access
- From: Br@dley
- access to Access
- Prev by Date: Re: Method Not Found, Access 97/2000 Conversion
- Next by Date: Re: Method Not Found, Access 97/2000 Conversion
- Previous by thread: Re: access to Access
- Next by thread: Method Not Found, Access 97/2000 Conversion
- Index(es):
Relevant Pages
|
