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

> On Fri, 23 Jan 2009 11:14:01 -0800, Jamie Dickerson
> <JamieDicker***@discussions.microsoft.com> wrote:
>
> 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
>
>
>
> >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.
>