How Do I Create A Multi-User Database?

[Guest]

The requirement is to create a multi-user database. By that I mean the
following:

The front end is a form that allows users to browse records in a table. Some
of the fields in the form read directly from the table, others run read
statements thru queries.

The requirement is to allow multiple users to browse simultaneously. Since
there are no updates users will be able to make via the form, there is no
need for record locks.

There is also a requirement that the table and the queries not be accessible
to the users.

Can anyone help?

 

[Rick B]

What specifically do you need to know?

You would build a query to run with owner's permission and base your form on
that query. You'd make sure the users had no access to any of the objects
other than your form.

Post back if you have specific questions as you work on this project.