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 wrote:
> 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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

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 wrote:

> 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 wrote:
> 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.

Access security and the macro security setting have absolutely nothing to do
with each other.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

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

"Rover" <(E-Mail Removed)> wrote in message
news:5fydnTAPfoJRnlnfRVn-(E-Mail Removed)...
>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
>

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.

"Rover" <(E-Mail Removed)> wrote in message
news:j96dnXPXJau3jVnfRVn-(E-Mail Removed)...
> 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 wrote:
>
>> 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
>>
>

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

"John Slattery" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> No. You're talking about code security. The concept is new to Access
> 2003.
>
> "Rover" <(E-Mail Removed)> wrote in message
> news:5fydnTAPfoJRnlnfRVn-(E-Mail Removed)...
>>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
>>
>
>