[AccessD] Permissions Refresher

Gustav Brock gustav at cactus.dk
Wed Apr 14 12:45:51 CDT 2004


Hi Mark

> I have a database that is currently restricted (by folder permissions) to
> only a few individual persons.  I am now in the process of creating a
> database for general use that needs to link to a table in that restricted
> database.  Out of the following permissions, what is the minimum necessary
> to allow a user to execute select queries, but not allow any modifications
> to the data?

I don't think you can do this as you for the new user group would need
to have two levels of permissions: read-only for the data file, and -
as for the first group - create-read-write (or better:
create-read-write-erase) for the the locking file (.ldb).

This article covers your initial scenario but not your requested
scenario, "Restrict The People Who Can Use Your Database Folder":

  http://www.vb123.com/toolshed/04_docs/accessdb_op_security.htm

However - as William will know - if you really need this setup, go and
get a Novell NetWare server. Here you can control user permissions
down to the single file; this scenario could be created in two
minutes. 

/gustav




More information about the AccessD mailing list