Database Security - set object permissions?

[naminder]

I am currently developing a security logging in system for databases I support over the network. .mdw files are no good for me as each database is delivered to a desktop, this would require the user to link to a different .mdw each time they used each database.

Anyway! Is there any code to set permissions on all forms after the user has passed my logging in script. I have built a form to capture username/password. Check details then i want the user to be able to either view, enter or modify records throughout? Basically duplicate the .mdw approach

 

[ghudson]

Not with true security that will actually protect the database objects and data records.

The MDW route will allow you to do what you want. All you have to do is create a custom shortcut that points to each workgroup file so that the secured db will open with the correct workgroup file. Never join a computer to a workgroup file [other than the default System.mdw]. Search around for there are plenty of threads discussing this.

 

[naminder]

http://support.microsoft.com/kb/305542/

Thanks, found above link after searching for what you suggested. All about putting it in the shortcut command line to reference the .mdw file for that database.

 

[ghudson]

System.mdw Access Workgroup Security

http://support.microsoft.com/kb/305542/

That is a great link for I have never seen that article before but it should be a must read for anybody trying to understand how and why a secured database works.

Understanding the role of workgroup information files in Access security