Permissions

[Guest]

I have admins and users. I want to keep Users from seeing the database window
icon in the toolbar, but leave it for admins. Even though I give users no
permissions for deletions in tables, they can access database tables and
delete data.

It's a shared database on a server where more than one can access it at a
time. Format is 2000, but machines have been upgraded to 2003. The
administrator left and I am doing the work, but the permissions don't seem to
be holding. I have locked myseld (as admin) out of administering queries and
also from haveing the menu bar to get functions back, Thank goodness for
backups.

Any suggestions? I read about opening in a workgroup, but that's not making
sense as I am working on it at work on the server, on my PC and now I brought
it ome on a flash drive. Am I killing any permissions I have set? Do I need
to clean out the registry abd start again?

Thanks. Any suggestions would be helpful...before I run out of backups!!!

Ron Beck

 

[Joseph Meehan]

I have admins and users. I want to keep Users from seeing the
database window icon in the toolbar, but leave it for admins. Even
though I give users no permissions for deletions in tables, they can
access database tables and delete data.

It's a shared database on a server where more than one can access it
at a time. Format is 2000, but machines have been upgraded to 2003.
The administrator left and I am doing the work, but the permissions
don't seem to be holding. I have locked myseld (as admin) out of
administering queries and also from haveing the menu bar to get
functions back, Thank goodness for backups.

Any suggestions? I read about opening in a workgroup, but that's not
making sense as I am working on it at work on the server, on my PC
and now I brought it ome on a flash drive. Am I killing any
permissions I have set? Do I need to clean out the registry abd start
again?

Thanks. Any suggestions would be helpful...before I run out of
backups!!!

Ron Beck

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

 

[Guest]

Thanks, Joseph. I'll see what I can dig out there.

Ron

I have admins and users. I want to keep Users from seeing the
database window icon in the toolbar, but leave it for admins. Even
though I give users no permissions for deletions in tables, they can
access database tables and delete data.

It's a shared database on a server where more than one can access it
at a time. Format is 2000, but machines have been upgraded to 2003.
The administrator left and I am doing the work, but the permissions
don't seem to be holding. I have locked myseld (as admin) out of
administering queries and also from haveing the menu bar to get
functions back, Thank goodness for backups.

Any suggestions? I read about opening in a workgroup, but that's not
making sense as I am working on it at work on the server, on my PC
and now I brought it ome on a flash drive. Am I killing any
permissions I have set? Do I need to clean out the registry abd start
again?

Thanks. Any suggestions would be helpful...before I run out of
backups!!!

Ron Beck

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.