Hmmm Need Help

[Wilfy06]

Was wondering if any of you fine people know a solution for this? have searched but could not find anything suitable.

I want to put an "administrator" type function into my database, only one person will use database at any time, however these people do not understand Access and will only be using the forms Page, i do not want them to have access to design, datasheet or any other view for that matter. but i will do when making alterations, so need to add some sort of security for me to have access.

Just ask me if you need to know anything that would eventually help me? if that makes sense.

Thanks in advance
David

 

[statsman]

Go to:

http://www.geocities.com/jackmacd

Download the first selection:

Security Paper by Jack MacDonald

It should be titled "Access Security for Dummies".

 

[Wilfy06]

When i clicked to follow link it said page not available. is there another link?

 

[statsman]

Sorry

Should be
www.geocities.com/jacksonmacd

 

[CEH]

If you are not in need of strict security, one thing I do is split the DB, and create 2 frontends. One for users, one for me. The one for me has different forms and functions that the users frontend does not. ie.... I can edit records from mine, the users cannot. You can also save their frontend as a "mde" file.

 

[Wilfy06]

Thanks for update on link statsman, and i'm liking the Idea bout the 2 front ends but this still wouldn't help me stop them from accessing the design view and datasheet view. but think great Idea and would look better Thanks for your help.
David