Access 2003 security setting

[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

 

[Rick Brandt]

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?

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.

 

[Rover]

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

 

[John Slattery]

No. You're talking about code security. The concept is new to Access 2003.

 

[John Slattery]

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.

 

[John Slattery]

Sorry about this post. It's getting late. Hadn't noticed Rick's.