shep said:
database developed using MS ACCESS 2003
Resides on server for multiple users. I need reference for establishing
user level security. If I use wizard on one PC, will it be in effect for
all
PCs connected to server?
The data only should sit on the server. The database should be split, with a
copy of the application on each workstation, linked to the data on the
server.
User -level Security is usually best pointed to a workgroup security.mdw
stored on the server (for easier administration).
There are 2 schools of thought controlling whether and how the database on
the server is secured. If the users are not sophisticated, it is often
sufficient to leave the database on the server unsecured, save for the
security on the server itself. The file is placed in a secure folder that
only bonafide users can access.
If you need more stringent security, including possible exclusion of your
own users to specific data, deny rights to anyone other than the database
owner, and allow access only through WITHOWNERACCESSOPTION queries which
will be automatically built if you've checked the appropriate radio button
in Tools > Options > Tables/Queries > Query Permissions.