Read Only Access to a Front End and Back End Database

[Guest]

I am doing consulting for an optician's office, and he wants to have two
computers have read-only access, and one computer that can edit data. I was
thinking about setting up user accounts, because it would be nice to just
allow certian users read only access, and other users full access-which would
have the most flexibility. Is it possible to restrict editing on both forms
and tables for a specific account using the user accounts?

Much Thanks

 

[Joseph Meehan]

I am doing consulting for an optician's office, and he wants to have
two computers have read-only access, and one computer that can edit
data. I was thinking about setting up user accounts, because it would
be nice to just allow certian users read only access, and other users
full access-which would have the most flexibility. Is it possible to
restrict editing on both forms and tables for a specific account
using the user accounts?

Much Thanks

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

 

[Pat Hartman\(MVP\)]

I would add to that, make sure you have several backups in a safe place and
read and follow exactly the directions from the Security FAQ that can be
found in the MSDN library or Knowledgebase.

I am doing consulting for an optician's office, and he wants to have
two computers have read-only access, and one computer that can edit
data. I was thinking about setting up user accounts, because it would
be nice to just allow certian users read only access, and other users
full access-which would have the most flexibility. Is it possible to
restrict editing on both forms and tables for a specific account
using the user accounts?

Much Thanks

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily
lock you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.