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

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

Relevant Pages

  • Re: MS Access - Only one person can open database at a time
    ... one person can get into the database at a time. ... Is the second user getting an error message? ... Is the scenario UserA can get into mdb and UserB can't? ...
    (comp.databases.ms-access)
  • 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)
  • Re: Building Access Applications "Inventory"
    ... Your form is based on an AutoLookup query that is based on more than one ... database engine saves the entire record, instead of saving only the field ... Set the OnClick property of the command button to the following ... value of the CategoryName field and that no run-time error message appears. ...
    (comp.databases.ms-access)
  • dont want users to be able to change data unless they have pushed a button
    ... I have created the database for different users and some of them might change ... I have also provided for several command buttons on the forms. ... and that they can only edit data when they push an edit button. ... error message "the command or action 'SaveRecord' isn't available now. ...
    (microsoft.public.access.formscoding)
  • Re: WSS 3.0
    ... Database signatures". ... the last command force the Windows SharePoint Services 3.0 upgrade by using the Psconfig.exe tool at a command prompt. ... Based on your last reply and new information, last Psconfig.exe tool reported error message "Failed to initialize SharePoint Products and Technologies upgrade." ...
    (microsoft.public.windows.server.sbs)