Hi Marc,
I find it best not to use Access security ... Instead use the network
security that you have (or will) set up.
Create a front-end and a back-end for your database
The front-end has all the queries, forms, reports, macros, modules, and
links to all the tables. Each person who has access to the database
will have a copy of the front-end
you may have more than one back-end
For instance,
there may be tables that everybody can read and write to. The database
with these tables would go on an area of your server with public
read/write privileges
You may have financial data that only the accounting group is allowed to
read and write. The database with these tables would reside in the
accounting groups shared area.
There may be tables, such as employees, that only the personnel
department is allowed to change, but everybody can view them. Put that
database in a directory where the accounting group has write priviledges
and the public has read access.
If you can use network security, it works great.
Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*