How Do I Create A Multi-User Database?

2 Nov 2005 5:24 PM

Bob

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?

--
Thank you,

Bob

2 Nov 2005 5:59 PM

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.

--
Rick B

Show quoteHide quote

"Bob" <B**@discussions.microsoft.com> wrote in message
news:1311F46C-FE8B-45DD-A728-282C590E862C@microsoft.com...
> 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?
> --
> Thank you,
>
> Bob