Prevent being open in Design mode...[Rather why is my access opening in design mode?]

[pedie]

Hi, I want to prevent being open in Design mode...
For now when i open the form, and right click on title section it give me options to desgin....which i do not want to....

Thanks for helping

 

[pedie]

sorry i just need to go to Tools menu, startup and disable the menus from there...

Sorry for trouble & thanks!

 

[Norie]

Pedie

You want to disable the ability for you to view a form in design mode?

How will you make changes to it?

 

[pedie]

You want to disable the ability for you to view a form in design mode?

yes Norie, but it is resolved now...
Thanks for helping!

 

[Norie]

Pedie

Am I missing something?

You want to make it so that you yourself can't open forms in desgin mode?

Do you actually want to stop other people viewing the form in design mode?

 

[pedie]

Pedie

Am I missing something?

You want to make it so that you yourself can't open forms in desgin mode?

Do you actually want to stop other people viewing the form in design mode?

Yes Norie, that is correct! I want to be able to open it without design view enabled...I was seeing design view when i open the front end

 

[HiTechCoach]

Before deploying the front end to user should compile the front end into a MDE/ADE/ACCDE. This disable the ability to modify forms, reports, and modules.

To make design changes you use the "master/source code" database (.mdb/.accdb/.adp) to make changes. The compile a new front end for deployment. You never let the yser have access to your "master/source code" database.

 

[pedie]

Before deploying the front end to user should compile the front end into a MDE/ADE/ACCDE. This disable the ability to modify forms, reports, and modules.

To make design changes you use the "master/source code" database (.mdb/.accdb/.adp) to make changes. The compile a new front end for deployment. You never let the yser have access to your "master/source code" database.

HiTechCoach, this is very interesting...Is there any set of intrucitions i follow to do/understand this, maybe some link..."to compile the front end into a MDE/ADE/ACCDE". 'm new to access database.

Thanks again

 

[Norie]

Pedie

If you are using Access 2010 (or 2007?) just goto the File tab, then Save & Publish and choose Make ACCDE.

 

[pedie]

Pedie

If you are using Access 2010 (or 2007?) just goto the File tab, then Save & Publish and choose Make ACCDE.

I see only two options to publish that is [Documents management server and package and sign], how when i choose package and sign it say i dont have "No certificates aVAIlable" and other says "You cant save here...choose another location" in all my other drives too.

Please advice, on exactly what i need to do.

Thanks again.