How to set a form unreadable

[Emma]

Hi I was wondering I had a from that only certain users (Admin) could access.
Now that I've changed my security file to include New Data Users the basic
function of keeping the users out of this form has been lost and all users
can now access this form. How do I keep normal users out of the Admin form?

 

[Hans Up]

Hi I was wondering I had a from that only certain users (Admin) could access.
Now that I've changed my security file to include New Data Users the basic
function of keeping the users out of this form has been lost and all users
can now access this form. How do I keep normal users out of the Admin form?

Remove Open/Run permission for your admin form from any group who you
want to keep out of the form. Those groups don't need Read Design,
Modify Design, or Administer permissions for your form, so you should
remove those as well. But I think removing only Open/Run will be enough
to keep them out.

If you have assigned object permissions directly to individual users,
you will have more work to do.

Make sure you have recent and tested backups of both your mdb and
security file (mdw) before changing permissions in the database.

Good luck,
Hans

 

[Emma]

Hi Hans up

I'm not sure how to do this as I'm using 2007? Any ideas?

Thanks Emma

 

[Hans Up]

Hi Hans up

I'm not sure how to do this as I'm using 2007? Any ideas?

If you're using Access 2007 with an mdb database which has user level
security, you can choose "Database Tools", then in the "Administer"
area, click on "User and Permissions", and choose "User and Group
Permissions ...".

Does that point you in the right direction?

Hans

 

[Emma]

Is there any other way to make the form unreadable, ie some code I could use
as the permissions isn't working.

Thanks Emma

 

[Hans Up]

Is there any other way to make the form unreadable, ie some code I could use
as the permissions isn't working.

Perhaps you could add code to the form's open or load event to request
the user supply a pass key value. If the user-submitted value doesn't
match the value hard-coded as a constant in the form, spit up a message
"Access Denied.", then automatically close the form.

But that seems kind of kludgey to me. I've never tried, so don't have
any code to offer.

If it were me, I would prefer to fix the user/group permissions so only
your Admins group would be allowed to open the form.

You're the same Emma who sent me a database a while back, right? If you
want to send me a zip (same email address as before) of your mdb and mdw
files, and tell me the name and password for one of your users in the
Admins group, I might be able to fix it for you. I would also need the
name & password for a non-Admin user to verify the fix works.

I don't think there is anything else I can offer you on this.

Hans

 

[John W. Vinson]

Is there any other way to make the form unreadable, ie some code I could use
as the permissions isn't working.

Use a Query as its Recordsource, and set the query type to Snapshot.