Split Database Front End User Privaledge

[mopat]

Hello,

I was wondering if anyone knows how to make the front end of a split database secure so that when opened, the user cannot have access to changing the design or code.

I pretty much need it to follow the same format as the file attached below. Does anyone know how to do this. Thanks for your time.

 

[CEH]

simpliest way for what you are wanting is just make the users frontend a "mde" file.

 

[boblarson]

And do a search here for

Disable Bypass Key

and then in the Startup Options make sure to UNCHECK the USE ACCESS SPECIAL KEYS so they can't hit F11 to get to the database window.

 

[mopat]

Thanks for all your help,

Im able to hide all tools that can change the form so that users dont have that option. I just showed the complete form to my boss and now he owes me lunch.

 

[boblarson]

Cool, glad that helped.