Access 2003 security setting

30 Jun 2005 2:38 PM

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

30 Jun 2005 2:43 PM

Rick Brandt

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

30 Jun 2005 3:30 PM

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

Rover wrote:

Show quoteHide quote

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

30 Jun 2005 11:03 PM

Rick Brandt

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

1 Jul 2005 5:16 AM

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.

Show quoteHide quote

"Rover" <rover44***@RemoveThisStuffNetscape.net> wrote in message
news:j96dnXPXJau3jVnfRVn-jQ@massilloncabletv.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
>>
>

1 Jul 2005 4:55 AM

John Slattery

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

Show quoteHide quote

"Rover" <rover44***@RemoveThisStuffNetscape.net> wrote in message
news:5fydnTAPfoJRnlnfRVn-oA@massilloncabletv.com...
>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
>

1 Jul 2005 5:18 AM

John Slattery

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

Show quoteHide quote

"John Slattery" <anonym***@microsoft.com> wrote in message
news:OFS8okffFHA.3692@TK2MSFTNGP09.phx.gbl...
> No. You're talking about code security. The concept is new to Access
> 2003.
>
> "Rover" <rover44***@RemoveThisStuffNetscape.net> wrote in message
> news:5fydnTAPfoJRnlnfRVn-oA@massilloncabletv.com...
>>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
>>
>
>