How do you lock the users out of EDIT mode of the database

[ToyFox]

How can I set an app so that the ribbon is always hidden...I dont want the users playing with anything....
I don't want them to get into edit mode.

 

[alvechurchdata]

If you distribute it as an accde file then they won't be able to alter the design of the forms or reports. Is this what you're trying to achieve?

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[ToyFox]

Kind of...currently is an MDB... It will reside on a shared network drive. There really is no distribution. Will your idea still work if it resides on a shared drive.

 

[jrbarnett]

Yes - the MDE files (for access 2003 and earlier) or ACCDE files (for 2007) prevent:

* access to VBA source code
* form and report design
* macros
* the database window (2003 and earlier) / navigation pane (2007)

You need to keep a copy of the original source code in a safe place, if changes are needed you make it in there then recreate the MDE/ACCDE and update that.

John

 

[alvechurchdata]

It will reside on a shared network drive.

This is causing me a slight worry. You have split the data and the user interface into two separate Access databases haven't you? What you need is a shared mdb holding the data and then individual accde or mde files, one for each user.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[MJD1]

hi, theres also another solution that I'm using in a DB I recently created. check out this FAQ faq181-1172. There is one thing to know, it appears that in MS access 2007, the "ChangeProperty "StartupMenuBar", dbText, "(default)", Restart" doesn't work. I simply removed this line and everything else worked well.

I have a table with user profiles. My users are granted either "Admin" or "User" level access. When the DB front end is opened, through a welcome window, this code will look to determine which level access the person has and open with the appropriate settings.