Hi everyone. I was hoping someone could help me with this small issue. What I want to do is allow users of my database read/edit only access. However, I am aware this can be bypassed by holding down the shift key and selecting the DB which brings them to design mode. This is something I would need if for example I needed others to go to design mode. When I put this on network drive I dont want people being presented with design mode as they could hamper the DB. Anyone any ideas please I would be most grateful?

Ruman-
So you want to allow the users to be able to change DATA but not the database design or report/forms objects? If so, open your db, choose tools/start up. on "Display Form/Page" select your opening form (Switchboard)from the dropdown. Then unselect "Display Database Window". Save, and close. Your users will now be taken directly to the opening form when they launch your app. Unless, of course, if they use the bypass key.

HTH,
Loralee

Rumon,

The best practise is to make MDE file and and apply ShiftByPassKey module (code) alongwith your db and then distribute. This will prevent user from re-designing your db objects such as Forms, Report, Queries, Macros, Pages & Modules. You must keep your startup form in the startup of the database before making MDE.

But make sure to have a backup copy of your db first before implementing this method.

Remember, making of MDE without ShifByPassKey setting would still give a chance to user to play with some of the objects like queries and macros.