Pratical Security

[A_Rodrigues]

Hi
A friend of mine is a beginner but needs to manage an Access database set of
users, accounts and permissins. I found Access permissions a little hard to
implement and explain. Moreover, the database may move from one computer to
another which may atract additional trouble. Please tell me your ideas
about implementing a more PRACTICAL WAY (even not so secure) if there is
one, of giving access through some sort of users/passwords criteria. Users
are of two types: One has all permissions, the others only read data and run
queries, reports, ... without update or design facilities.
Thank you.
A_Rodrigues

[Larry Linson]

Access' security, difficult though it is, and fallible though it is, is the
only reliable way to do what you want. You can prevent users changing code,
forms, or reports by compiling to MDE format, but they can still change
tables, queries, and macros.

Larry Linson
Microsoft Access MVP

"A_Rodrigue s" <am************ *@netvisao.pt> wrote in message
news:ne******** ************@ne wsfront4.netvis ao.pt...

Hi
A friend of mine is a beginner but needs to manage an Access database set of users, accounts and permissins. I found Access permissions a little hard to implement and explain. Moreover, the database may move from one computer to another which may atract additional trouble. Please tell me your ideas
about implementing a more PRACTICAL WAY (even not so secure) if there is
one, of giving access through some sort of users/passwords criteria. Users
are of two types: One has all permissions, the others only read data and run queries, reports, ... without update or design facilities.
Thank you.
A_Rodrigues

[BugBear 55]

"Larry Linson" <bo*****@localh ost.not> wrote in message
news:k8******** **********@nwrd dc03.gnilink.ne t...

Access' security, difficult though it is, and fallible though it is, is the only reliable way to do what you want. You can prevent users changing code, forms, or reports by compiling to MDE format, but they can still change
tables, queries, and macros.

Larry Linson
Microsoft Access MVP

"A_Rodrigue s" <am************ *@netvisao.pt> wrote in message
news:ne******** ************@ne wsfront4.netvis ao.pt...

Hi
A friend of mine is a beginner but needs to manage an Access database set

of

users, accounts and permissins. I found Access permissions a little hard

to

implement and explain. Moreover, the database may move from one computer

to

another which may atract additional trouble. Please tell me your ideas
about implementing a more PRACTICAL WAY (even not so secure) if there

is one, of giving access through some sort of users/passwords criteria. Users are of two types: One has all permissions, the others only read data and

run

queries, reports, ... without update or design facilities.
Thank you.
A_Rodrigues

Best place to get answers is at the official MVP site:
http://mvp.org
BugBear 55 (ex-MVP)