Allowbypasskey property

[dvorett]

I was wondering if there was a way to set a specific property to
different vallues depending on the user?
I need to users of the database to be able to add, edit, and read data
in the forms but not be able to change the design in anyway. I have
all the settings the way I want and then I figured I could just hold
the shift on startup when I log in as the administrator, unfortunately
that also works for the other users. Can I set allowbypasskey to false
for user and true for administrator.

Any help would be greatly appreciated
Thanks a bunch
Dan

[Keith]

"dvorett" <da********@hotmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Can I set allowbypasskey to false
for user and true for administrator.

I set the bypass key property to True for development and False for
production using a smart little utility developed by Albert D. Kallal:

http://www.members.shaw.ca/AlbertKal.../msaccess.html

There's a version for A97 and one for A2000.

HTH - Keith.
www.keithwilby.com

[dvorett]

Thanks a lot Keith, that did the trick!