Secure part of a db?

[Sherlock]

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]

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

 

[Sherlock]

Thanks, Keith. No offense taken!

I'll check with the associate I'm building this for and see what he thinks.
If he thinks disabling things is enough, how do I do that so that the user
can't see anything but just the form?

Thanks.

 

[Keith Wilby]

Thanks, Keith. No offense taken!

I'll check with the associate I'm building this for and see what he
thinks.
If he thinks disabling things is enough, how do I do that so that the user
can't see anything but just the form?

Setting the start-up options should take care of that.

Keith.