Unable to click "Enable Content" unless in Design View

[jonathanchye]

I've just designed a user login screen and tried distributing it on a client PC. The usual warning came up but I noticed I can't click the Enable button.

The only way I can click the enable button is to right click and select Design view. I haven't notice this behaviour before when developing in Access 2007 (I am using Access 2010 now).

This would of course cause a problem when I distribute it later as ACCDE to end users. Any idea why I need to go into design view to click the Enable content button?

 

[boblarson]

You need to have them set up the database location as a trusted location and that way there is no need to click the button.

 

[boblarson]

oh and on Windows Vista / Windows 7 you can't save to the Root (C:\) and you can't save to C:\Program Files.

 

[jonathanchye]

You need to have them set up the database location as a trusted location and that way there is no need to click the button.

Hmm, it would be saved to each of the user's Citrix published desktops...

However, this wasn't a problem in the past. Must be some settings which caused this. It just won't allow me to click anywhere else when in Form view. I can only click on the form's controls.

I usually disable right click on the ACCDE (which I doesn't have design view anyway) but if they can't click the enable button then it would be a problem.

 

[jonathanchye]

Anyone know why I can't click on the Enable Content button? This never happened before and it must be one of the security features. I find this pretty annoying as I set the DB to open a login form on open. If the form is open there's no way I can click anywhere else but on the form area. If I click anywhere else the form just blinks.

edit: I think I've found out why. The login screen was created using the wizard which I've selected as "Modal Dialog". So basically if you select the option "Modal" on the property to Yes this will prevent users to click elsewhere. Not sure what "Pop up" option does.

This is perhaps good in certain forms where you want to make sure users don't click anywhere else

 

[boblarson]

Yeah, modal would do it. Modal means that nothing can be done until you click that button. So, if you want it to work before clicking the enable button you would have to use an embedded macro with a "safe" action.