"Sherlock" <Sherl***@discussions.microsoft.com> wrote in message
news:CE77220F-D1F5-48E0-A867-A9DDF2E3CB35@microsoft.com...
>I have a small 2003 or 2007 database (have started in both, trying to
> accomplish) with just 4 or 5 tables and a handful of forms. One form is a
> questionnaire that associates are supposed to fill out. The questionnaire
> ultimately links to all of the tables. I do not want associates to be able
> to
> look at any of the other forms or the tables containing the results of the
> questionnaires.
>
> The questionnaire is set for data entry and I have buttons on the
> questionnaire so that when the associate Saves or Cancels, it immediately
> closes the database. Everything else should be available only to the
> training
> dept staff.
>
> What I can't figure out is how to keep associates from clicking other
> items,
> such as the tables or other forms, and opening them. I'm pretty much of a
> novice with Access. I thought about moving the form to another database,
> but
> if I link it to the db with the info, associates could still open the
> linked
> tables in Read Only view, and if I password the main database, the
> questionnaire database can't access it, right? At least that's what
> happened
> when I tried to do that.
>
> Thanks for your help!

"Keith Wilby" wrote:

> "Sherlock" <Sherl***@discussions.microsoft.com> wrote in message
> news:CE77220F-D1F5-48E0-A867-A9DDF2E3CB35@microsoft.com...
> >I have a small 2003 or 2007 database (have started in both, trying to
> > accomplish) with just 4 or 5 tables and a handful of forms. One form is a
> > questionnaire that associates are supposed to fill out. The questionnaire
> > ultimately links to all of the tables. I do not want associates to be able
> > to
> > look at any of the other forms or the tables containing the results of the
> > questionnaires.
> >
> > The questionnaire is set for data entry and I have buttons on the
> > questionnaire so that when the associate Saves or Cancels, it immediately
> > closes the database. Everything else should be available only to the
> > training
> > dept staff.
> >
> > What I can't figure out is how to keep associates from clicking other
> > items,
> > such as the tables or other forms, and opening them. I'm pretty much of a
> > novice with Access. I thought about moving the form to another database,
> > but
> > if I link it to the db with the info, associates could still open the
> > linked
> > tables in Read Only view, and if I password the main database, the
> > questionnaire database can't access it, right? At least that's what
> > happened
> > when I tried to do that.
> >
> > Thanks for your help!
>
> It depends how Access "savvy" your users are.  If they're unlikely to know
> about the bypass key then all you need to do is remove all of the start-up
> options (tools, startup).  As implied, holding the shift key down whilst
> opening the file will bypass those startup options and show the full
> database window.
>
> If your users know about that then you're probably looking (at least) at
> providing an mde file and/or applying user-level security, which is probably
> not a job for a novice (no offence intended).
>
> Keith.
> www.keithwilby.co.uk
>
>