Security for a MDB

[KLerma]

All,

I have a question about security withing Access. I have a rogue user that loves to create/modify my forms and code behind the form. I need to know how to stop him from doing this. Any ideas??

Thanks,

kev

 

[FoFa]

Don't allow acess to the forms. There are different ways to do this, I would try using a startup page, and disable special access keys, and don't show the designer (database) view. But keep a seperate copy for you to use for maintance, makes it easier. If you want even more security, try saving it as an MDE (use HELP).

 

[jfgambit]

Use Access' built in security features. It will allow you to grant read, write and design abilities to users.

Then following is a link to MS about FAQ in regards to Access security:

http://support.microsoft.com/default.aspx?scid=kb;en-us;165009&Product=acc

 

[KLerma]

I will look into both ideas.

Thanks again,

Kev

 

[ghudson]

In addition to using Access built in security you should check out the code I posted in the link below for how you can hide/disable certain parts of the db.

http://www.access-programmers.co.uk/forums/showthread.php?t=62198

 

[Pat Hartman]

If all you want to keep him out of is the forms/reports design and any code, you can create an .mde and distribute that rather than the .mdb. Making an .mde will not prevent him from creating his own queries/macros or modifying yours. You would need to implement full blown Access security to do that.

If you do create an .mde, make sure to keep the .mdb in a very safe place. An .mde cannot ever be converted back to an .mdb by any means, even third-party alternatives because, the source code is actually removed from the db as the .mde is created.

 

[paulreed]

Check out This Link which works well for me in a similar position.
You can assign passwords to those who need the app, and if someone modifies a form, you always have the log file, to see who logged on and off.
Its only low-level security, which anyone with a knowledge of access could bypass, but would deter most people.