Access 2000 Security

[Jamie Dickerson]

I am an Access novice and I need to keep people from altering the records
(other than myself). I have several tables, queries and reports. I have
tried using the User-Level Security Wizard which works except that it locks
me out as well. I also make sure that I am listed as the admin. and I am the
owner. Can anyone help me?

Thanks in advance.

 

[Tom van Stiphout]

On Fri, 23 Jan 2009 11:14:01 -0800, Jamie Dickerson

ULS is an advanced topic you should not touch until you first
download, study, and fully understand the Security FAQ from
microsoft.com.
ULS has been removed from Access 2007's new accdb format (hint, hint).

A simple solution would be to ask Windows who is logged in:
http://www.mvps.org/access/api/api0008.htm , and if it is other than
you, you set Me.AllowEdits to false.

-Tom.
Microsoft Access MVP

 

[DJH6064]

You may also want to take a look to see if the database security has the
"Open Exclusivly" option selected.