Locking down Access

[snipe]

Hey guys,

Security question.

Our front end users all are part of my CustSvc group. I have hidden the main window (forgot what its called, but its where you pick queries, tables, etc). I have recently learned that my users are opening up my table, after unhiding it, and changing data. Not only is this dishonest, against company policy, but it could easily corrupt the database.

The users need to be able to read, and update data to this table. It is supposed to be done through a form. On this form, all they can do is add an "x" in the void field.



How can I prevent users from opening up anything without using buttons on the main switchboard?

[June7]

Can use Access Options to disable the Navigation pane, ribbon, shortcut keys, function keys.

Be aware that holding down shift key while opening db will bypass most of the Option settings.

Review http://office.microsoft.com/en-us/ac...010341741.aspx

[snipe]

Ah good to know. We are on 2003, but I'll keep digging with 2003 security documents. Thanks a bunch June7

[June7]

Also, if users know location of the backend db, they can just go directly there, unless the backend has password protection.

[snipe]

Using this:

http://www.access-programmers.co.uk/...ad.php?t=97578

Unless you know of a better option?

Also unchecked the "use access keys" so they can't hit F11, etc

[June7]

I never used 2003 very long and never set up db with security so your research is as good as any.

[snipe]

Alrighty. Appreciate it as always!