Re: MS Access - Only one person can open database at a time



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?
.



Relevant Pages

  • Re: Record Locking for Editing.
    ... backend database. ... If you want plan to use DB2, you should make sure that you won't have two ... Now the second user is gettiing error message as "No Current Record" ...
    (microsoft.public.access.modulesdaovba)
  • Login failed for user (null). Reason: Not associated with a trus
    ... I got the following error message when I access the web application, ... the web application use SPPI to connect to database. ... I have two 2 accounts, userA and userB, which belong to the same group ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: MS Access - Only one person can open database at a time
    ... Do you have /excl in the command line to open the database. ... Is the second user getting an error message? ...
    (comp.databases.ms-access)
  • Re: Login failed for user (null). Reason: Not associated with a
    ... the database is installed on another machine from the web application. ... >>I got the following error message when I access the web application, ... >>I have two 2 accounts, userA and userB, which belong to the same group ... >>userB cannot and prompted the above error. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: DBD::Informix 2003.04 AIX4.3.3 SELECTIVE TEST ERRORS
    ... one which you could fix by removing the database). ... The bug report is below. ... > Informix Server Entries in sqlhosts file ... > # Error Message: ...
    (perl.dbi.users)