Re: MS Access - Only one person can open database at a time
- From: Salad <oil@xxxxxxxxxxx>
- Date: Wed, 13 May 2009 10:15:20 -0700
pcsmartz@xxxxxxx wrote:
On May 12, 2:31 pm, Salad <o...@xxxxxxxxxxx> wrote:
Trish wrote:
Hi,
I have a database in MS Access 2007, multiuser set up, however only
one person can get into the database at a time.
Thanks in advance for your help.
Trish
Do you have /excl in the command line to open the database.
Is the second user getting an error message? You might want to be a
little more verbose in your problem description...like error messages,
method of opening the file, and the like.
I will double-check the command line. Nothing happens at all when the
second user tries to get into the database. No errors...when trying
to open the file (double-clicking, or right-click and selecting Open)
the file does not respond at all. I checked to see if maybe it was
already running in the task manager, but it wasn't.
I appreciate your help on this...thanks again!!
Is your application split? Do you have a front end on each user's PC? And link the tables to a back end on the network?
Is the scenario UserA can get into mdb and UserB can't? How about UserB in and then UserA?
Is UserA modifying something like a form or report while UserB attempts to log in if not split?
.
- References:
- Prev by Date: Re: MS Access - Only one person can open database at a time
- Next by Date: main/subform query problem
- Previous by thread: Re: MS Access - Only one person can open database at a time
- Next by thread: Re: MS Access - Only one person can open database at a time
- Index(es):
Relevant Pages
|