COnverted Access 2000 to MDE how to keep others out of objects? 2

[Phideaux]

I've completed developing a access 2000 db., converted it to MDE. Now how do I keep casual users from poking around and looking at tables and other objects or viewing the structure of the DB?

This part of db developement is completely new for me, ANY help will be sincerely apreciated and needed.
Thanks,
Phideaux


The mind is the best toy.
Play with someone else's often

 

[jrbarnett]

Hi,

The MDE format will stop users fiddling with form/report design and VBA code, but if you set a startup form in tools -> startup and untick the "Show database window" this form will come up at startup.
You can set the AllowByPassKey property to false (check elsewhere in the Access forums for details on this) to stop the users bypassing the loading of the startup form by holding down shift at database startup, but this won't stop users pressing F10 to open the database window if they want to look around at the internal objects.

John

 

[Phideaux]

thanks for the information. Now the next thing I need to do is disable the F10 key?

The mind is the best toy.
Play with someone else's often

 

[hjgoldstein]

In startup options click on "Advanced" and disable Access Special Keys.

 

[Phideaux]

Thanks for your help i'll do that tonight!

The mind is the best toy.
Play with someone else's often