Security question (1 Viewer)

[BobNTN]

Is there a way to prevent data in a split DB from being imported by another program ?

 

[Guus2005]

There is not a watertight solution to do so. Access security is easily compromised. The tightest solution to shield your data is to use Access built-in UAC (User Account Control).

In a nutshell:
Create a brandnew workgroup file and use it to open your database. Now set the Admin password for the backend. Do the same for the frontend. Strip the Admin group from all its privileges. Create your own group and add users to them. Grant permissions to the group.
Don't loose the unique string you used to create the workgroup file.

Enjoy!

 

[BobNTN]

Thank you.

 

[mafhobb]

How to create a brand-new workgroup file?

How to set the admin password for the backend?

How to strip the Admin group of privileges and grant permissions to the other group?

Is there a simple sample db somewhere with this done so it can be studied?

Thanks

mafhobb

 

[JANR]

http://www.moretools.com/lessons/access_security.htm

word of caution, test this on a COPY first!!!

JR

 

[gemma-the-husky]

I always wonder why its a problem

Most systems intentionally expose (at least some) of their data via ODBC links.

Its generally a good feature, not a bad one.