Securing an Access Database 1

[kioko]

Hi Guys

I would like to secure an an access database application (it has a front and backend) but I find working with the workgroup admin utility very useless coz someone can just as easily change the .mdw file that is being used to enable and thus enabling themselves unlimited access to the database objects. Is there code which can be run on the startup of the database which will check the .mdw file being used and hence lock out users if the .mdw file has been changed?

 

[Rohdem]

I find working with the workgroup admin utility very useless coz someone can just as easily change the .mdw file that is being used to enable and thus enabling themselves unlimited access to the database objects.

Not unless they are an administrator. Check this link out:

http://support.microsoft.com/support/Access/Content/SECFAQ.asp

Mike Rohde
rohdem@marshallengines.com