Limit users to a form?

26 Oct 2006 8:48 PM

Cush

I have a form that generates the desired output based upon user slecting from
3 list boxes and hitting a button. I have currently been using the shift-open
method to hide the data and believe it or not it worked for quite a while.
Now that people are starting to get into the back end and play with the data
I am having version control issues arrise. I am looking for a way to limit
users to the form (password, etc...) so that they cant gain access to any of
the tables and/or add custom properties to the form to run their own reports.
Any suggestions?

27 Oct 2006 3:12 AM

tina

take a look at http://www.mvps.org/access/modules/mdl0011.htm

hth

Show quoteHide quote

"Cush" <C***@discussions.microsoft.com> wrote in message
news:B83E4536-C3F4-4AD8-BA6B-B24C0018D934@microsoft.com...
> I have a form that generates the desired output based upon user slecting
from
> 3 list boxes and hitting a button. I have currently been using the
shift-open
> method to hide the data and believe it or not it worked for quite a while.
> Now that people are starting to get into the back end and play with the
data
> I am having version control issues arrise. I am looking for a way to limit
> users to the form (password, etc...) so that they cant gain access to any
of
> the tables and/or add custom properties to the form to run their own
reports.
> Any suggestions?