We have created MS Access databases in order to report on and manipulate our company data. The back-end databases reside in there own directory on a Win2k server. We have also created a frontend .mde file (with links to the back-end databases) that is copied to each database user's local machine. There are users who will need to be able to write to the back-end databases (using there local .mde) and there are users who will only need to run reports (or only read) the information in the back-end databases (using there local .mde).

The problem is that we have to grant "full controll" to the back-end database directory for the users who need to be able to write to the back-end databases. Obviously, we do not want to do this because these users could access this directory and rename or delete these back-end databases.

Any help here?

Deez