Security Permission

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a dabase on a file server. When you give some full privileges and some
read only access, the full privileged individuals can not make changes
whenever a read only person is accessing the program. Would it be better to
control the security permissions on the server or within access?
 
BigTuna said:
I have a dabase on a file server. When you give some full privileges and
some
read only access, the full privileged individuals can not make changes
whenever a read only person is accessing the program. Would it be better
to
control the security permissions on the server or within access?
Click to expand...

Without a doubt from within Access, but it sounds as if your first problem
is a multi-user one - the classic, tried and tested configuration is to have
your app split into front and back ends, with a copy of the FE on each
user's machine.

Regards,
Keith.
www.keithwilby.com
 
Hi BigTuna,

You're mixing two very different security related things -

- Physical file security/privileges for users (i.e. network, OS related)
- Application security/privileges for users (i.e. Access application
related)

The two are separate and are not alternatives. You need to consider both.

All network users requiring the use of Access application must have full
rights to the network folder in which the mdb file resides. ( for
simplicity, let's call this Server security) This is the security that
determines who can start, execute, and use the application.

Application related security within the Access application itself is
optional based on your business requirements. (for simplicity, let's call
this Access security) This is the security that determines who can do what
functions within the Access application itself (i.e. who can read, update,
delete records, etc)

To answer your question:
Would it be better to
control the security permissions on the server or within access?
Click to expand...

Well.., again Server and Access securities are totally separate and are not
alternatives of one another. The decision is not to pick which one to use.
Each does its own things for its own purposes. Server security needs to be
considered in all cases; you must give all Access application users full
rights to the folder where the mdb file resides. Access security is
optional. You may or may not need it based on the nature of the application.


HTH,
Immanuel Sibero
 
Thanks Immanuel. I added an access group for the folder permissions allowing
full access (minus add permissions). From their I took Keiths advice about
adressing the specific permissions within access and it appears to be working
well. Thank you for the advice.
 
Back
Top