MS Access Security FAQ

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

Guest

I have downloaded and read the Access security FAQ and I think I finally
understand user level security. Except for the 10th and last step, it says:
"You may also need to manually remove the Open/Run permission from the
database container for the Users group through the security menus or through
code. This will prevent someone from opening the database by using another
workgroup information file or the default System.mdw."
Question: Exactly what is meant by 'database container'? If I remove these
permissions from my database, how will my users get into it?
Also what do these acronyms stand for?:
MDE
DAO
ADO

Thanx for the help,
Rip
 
Hi.
Question: Exactly what is meant by 'database container'?
Click to expand...

In this context, consider it to be the database file that one opens with
Access and is manipulated by the database management system. All database
objects, properties, methods, security permissions, et cetera, embodied in
this database application are contained in this file, the "database
container."
If I remove these
permissions from my database, how will my users get into it?
Click to expand...

Your users will also be members of another group which has Open/Run Database
permissions. A user may be a member of one group that lacks some
permission, but this does not preclude the user exercising permissions
granted to members of another group that the user is also a member of.
Also what do these acronyms stand for?:
MDE
DAO
ADO
Click to expand...

MDE: Microkernel Development Environment
DAO: Data Access Objects
ADO: ActiveX Data Objects

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top