Form lockdown

[maw230]

I would like for my front-end .accde Access 2007 files to be nearly completely un-editable. I don't want the users to be able to change a thing, while still being able to run Delete, Append queries, etc.

I haven't been able to find anything in the Options menu to do this.

 

[SpentGeezer]

I would like for my front-end .accde Access 2007 files to be nearly completely un-editable. I don't want the users to be able to change a thing, while still being able to run Delete, Append queries, etc.

I haven't been able to find anything in the Options menu to do this.

If the delete and append queries can be run from command buttons (end users are not actually creating the querries) then:

1) Use a .mde file for the front end
2) Use full screen forms with no close and minimize buttons, no control box so that the user can't get at the tables (navigation from form to form is done by command buttons)
3) Lock any form controls that could edit records
4) Have buttons to run the inbuilt querries, with forms for entering parametres.

This is how I control what can be edited / run. It is most likely noobish, and I am keen to learn better ways.....

 

[maw230]

Thanks for the reply Geezer. I think my title may have been misleading. The forms are all locked down properly, but the Navigation Pane is easily re-activated by anyone with the sense enough to search through the Access Options and click the appropriate settings. Once the Nav Pane is back the user can go through and edit various objects.

In other words, I am trying to lock down the entire .accde file.

 

[SpentGeezer]

I use forms that are full screen without any control box. You have to remove all the control box, minimize, maximize buttons etc. Make the form "popup" and set menu = 1. This will make the form take over the whole screen. See attached example. Change the file extension of the accdb to .mde as it is an mde file. Note that it is not possible to get to the menu items.