Finished Acces db. How should I set up for users?

[DPK99]

I have completed a db and am satisfied with the structure and forms. The object window is hidden when the database is opened, and the main entry form automatically opens for the user. This db will be in a network folder and several users will have access to it. I want people to be able to enter data and run reports, but not make any changes to the database itself, or accidentally delete the database file or some other change to the structure. What is the proper way to set up the folder rights and anything else associated with the previous question?

Thanks.

 

[DJkarl]

First off forget about folder rights, for Access to work properly on a network it pretty much needs full permission to the folder it resides in (read/write/modify/delete).

Suggestions:
You should have a split database (FE/BE)
To prevent changes to the front end make it an MDE file.

Preventing the users from deleting the file is not practical, if it is on a network then the server should be backed up regularly so this shouldn't be a concern, and if the backend is seperate from the front end keep the backend in a seperate folder and don't tell the end users where it is, they don't need to know, only the program needs to know. If the front end gets deleted you could put another copy out there and there would be no loss of data.