Error
- Thread starter 24sharon
- Start date
ghudson
Registered User.
- Local time
- Today, 18:15
- Joined
- Jun 8, 2002
- Messages
- 6,193
The cheap fix is to lower your Access Macro Security setting to LOW.
The expensive and yet professional fix is to use Digital Certificates. If the Access 2003 db will be used by others then you will have to purchase the Digital Certificate @ $400.
Search the forum for for info for there are a lot of threads concerning Access 2003 and the new security features [challanges] if offers.
Search keywords ... "Digital Certificates", "Access 2003 Security", "Macro Security", "Sandbox" (but not at the same time ;-)
Good luck!
The expensive and yet professional fix is to use Digital Certificates. If the Access 2003 db will be used by others then you will have to purchase the Digital Certificate @ $400.
Search the forum for for info for there are a lot of threads concerning Access 2003 and the new security features [challanges] if offers.
Search keywords ... "Digital Certificates", "Access 2003 Security", "Macro Security", "Sandbox" (but not at the same time ;-)
Good luck!
ghudson
Registered User.
- Local time
- Today, 18:15
- Joined
- Jun 8, 2002
- Messages
- 6,193
Not sure why your language version of Access 2003 does not have the option to change your settings @ Tools \ Macro \ Security... to LOW.
I think I have seen a posting somewhere in this forum before about not finding that option but I do not recall seeing the final result or help fix. Try searching [use relative key words] and see if you can find it.
Good luck!
I think I have seen a posting somewhere in this forum before about not finding that option but I do not recall seeing the final result or help fix. Try searching [use relative key words] and see if you can find it.
Good luck!
La La La
I got it...
here:
27. How do I change the macro security level in Access?
On the Tools menu, point to Macro, and then click Security. If you do not see the Macro menu item under the Tools menu, or the Security menu item under the Macro menu, click the arrows at the bottom of a drop-down menu to display the hidden menu items.
Tip If you want to see all menu items by default, on the Tools menu, click Customize, click the Options tab, and select the Always show full menus check box.
I still can't see the Security command under the Macro menu
On the Tools menu, click Customize, and then click the Commands tab.
Click Rearrange Commands, select Menu Bar, and in the Menu Bar box, click Tools, and then click Macro.
In the Controls section, click Add.
The Add command dialog box will appear.
In the Categories box, click Tools, and then in the Commands box, click Security.
The Security command will appear in the Controls box.
Use the Move Up and Move Down buttons to position the Security command where you want.
If you'd like to position the Security command in its own group (between horizontal lines), with Security selected, click Modify Selection and click Begin a Group. Select the menu item below the Security command, and repeat.
Click Close twice.
Click the Security Level tab, and then select the macro security level that you want to use.
this is from http://office.microsoft.com/en-us/assistance/HA011225981033.aspx#200
ghudson thanks alot
I got it...
here:
27. How do I change the macro security level in Access?
On the Tools menu, point to Macro, and then click Security. If you do not see the Macro menu item under the Tools menu, or the Security menu item under the Macro menu, click the arrows at the bottom of a drop-down menu to display the hidden menu items.
Tip If you want to see all menu items by default, on the Tools menu, click Customize, click the Options tab, and select the Always show full menus check box.
I still can't see the Security command under the Macro menu
On the Tools menu, click Customize, and then click the Commands tab.
Click Rearrange Commands, select Menu Bar, and in the Menu Bar box, click Tools, and then click Macro.
In the Controls section, click Add.
The Add command dialog box will appear.
In the Categories box, click Tools, and then in the Commands box, click Security.
The Security command will appear in the Controls box.
Use the Move Up and Move Down buttons to position the Security command where you want.
If you'd like to position the Security command in its own group (between horizontal lines), with Security selected, click Modify Selection and click Begin a Group. Select the menu item below the Security command, and repeat.
Click Close twice.
Click the Security Level tab, and then select the macro security level that you want to use.
this is from http://office.microsoft.com/en-us/assistance/HA011225981033.aspx#200
ghudson thanks alot
Attachments
Last edited:
