access+training - Supress Macro Security

access+training - Supress Macro Security - MS Access

Resolved · Low Priority · Version Standard

Supress Macro Security - MS Access

Timothy has attended:
Excel VBA course
Excel VBA course
Access Intermediate course
Access Advanced course

by - delegate Timothy [1 post] (2008 Jan 9 Wed, 15:49) Reply

Can you supress the Macro security prompt at startup other than by changing the individuals security option?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
Full Schedule: See all 52 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Supress Macro Security - MS Access

by - trainer Carlos gold contributer [479 posts] (2008 Jan 29 Tue, 12:53) Reply

Hi Timothy

One way to supress the Macro prompt at StartUp is to manually reset the computer's Macro security level. To do this:

1. Open Tools / Select Macro. In the Sub menu Click Security

2. On the Security dialog box select Low

3. Click OK

Although not recommended this allows all databases to open, without a prompt, even if they contain Macros.

Hope this helps

Carlos