multi users problem

[Guest]

Hi,

1-I have a database (name simplex.mdb) in shared folder and the users have
“full permissionâ€.
2-All users can open simplex.mdb, but when a user opens the form or a query,
other users have not opened the form or query.

Simplex,

 

[Joseph Meehan]

Hi,

1-I have a database (name simplex.mdb) in shared folder and the users
have "full permission".
2-All users can open simplex.mdb, but when a user opens the form or a
query, other users have not opened the form or query.

Simplex,

First point is you should split the database. A back end with the
dynamic tables and front ends with static tables queries, forms and reports,
on each user's machine linked to the tables in the back end.

I'd guess that would take care of the problem.

From the help file:

You can split a Microsoft Access database into two files: one that contains
the tables and one that contains the queries, forms, reports, macros,
modules, and shortcuts to data access pages. This way, users who need to
access the data can customize their own forms, reports, pages, and other
objects while maintaining a single source of data on the network.

On the Tools menu, point to Database Utilities, and then click Database
Splitter.

Follow the instructions in the Database Splitter Wizard dialog boxes.