Multiple users?

[Jacob]

We've finally completed our database, but it will only let
one person use it at a time. Is there something that I
need to do to the database to make it accessible by
multiple users. It lets users open to file, but will not
let them open the form.

 

[Tim Ferguson]

We've finally completed our database, but it will only let
one person use it at a time.

Check Tools - Options - Advanced and make sure that the default is to open
databases in shared (non-exclusive) mode.

By the way, if you are going to be using access in multiuser mode, which it
does very well, consider how you are deploying the system. A split Front
End/ Back End design is highly recommended -- more information in Help, or
by googling in these NGs.


HTH

Tim F

 

[Roy Goldhammer]

Well Jacob.

I don't understand what to want to do by opening the file and prevent other
users to open forms.

First of all on the Tools->Startup menu removed all options of developing:
you can find good help on these items or playing with them to see what it
does.

Secondly create your own menu bar by create macros that run the forms and
add it to the new menu that you create.

Thirdly create workgroup with users and on the startup form set that only
one user can watch the menu bar and other users can't (if the menu bar isn't
available other users can't access to any option of your application. Thats
what you asked