Access 2003 security setting

  • Thread starter Thread starter Rover
  • Start date Start date
R

Rover

I have just learned that under Tools | Marco | security I can set the
security to low. Can I somehow do that on Access 2000 or 2002?

Thanks
Jim
 
Rover said:
I have just learned that under Tools | Marco | security I can set the
security to low. Can I somehow do that on Access 2000 or 2002?
Click to expand...

Not sure it's possible but it should be unnecessary. The warnings that
A2003 hits you with when macro security is not set to low do not occur with
A2002 or A2000.
 
The real problem here is that I set up "secure" db in a2000. I'm sure I
screwed something up because I get some users that should have full
permissions not being able to access tables "owned" by anyone other than
the administrator. A co-worker set the security to low on one machine
and that got rid of security altogether. Excellent. That's what I want
- just to get rid of security for now. This seemed to be my way out.

I'm a simple programmer and really don't have the time right now to
learn the Access security system, nor is it necessary for this application.

Thanks
Jim
 
Rover said:
The real problem here is that I set up "secure" db in a2000. I'm
sure I screwed something up because I get some users that should have
full permissions not being able to access tables "owned" by anyone
other than the administrator. A co-worker set the security to low on
one machine and that got rid of security altogether. Excellent. That's what
I
want - just to get rid of security for now. This seemed to be my way
out.
I'm a simple programmer and really don't have the time right now to
learn the Access security system, nor is it necessary for this
application.
Click to expand...

Access security and the macro security setting have absolutely nothing to do
with each other.
 
If you want to /get rid of security/ on your database objects (as opposed to
telling access to run any code it encounters without bothering you), assign
all permissions for the database, its containers, and each of its
container's contents to the Users group. You can do this by going to the
Access menu bar and following Tools, Security, User and Group Permissions.
Perhaps an easier way would be to join the workgroup that secures your
application and create a blank database, logging on as a member of the
admins group when prompted. Then, import all of your database objects. If
you don't touch permissions on the new database, any user who is a member of
the users group of any workgroup will have complete control over the entire
database.
 
Back
Top