Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.
COURSE of the MONTH
8 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
'Action failed on AutoExec' error msg on app start-up
Posted on 2012-12-20
when you open this access app, you get the below screen. how can this warning be avoided? (Action failed on AutoExec)
when you click close, then you get the second screen. (vba macro)
this started happening only 2 months or so ago, i am told.
thanks.
when you click close, then you get the second screen. (vba macro)
this started happening only 2 months or so ago, i am told.
thanks.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
3
2- +1
10 Comments
Active today
Action failed on AutoExecYou would have to determine which action is failing in the AutoExec macro. If you can list those actions, we might be able to point you to some likely suspects.
sorry i had not put comment for attachment, and it was not loaded.. here is the screenshot
2nd-screen.png
macro.png
2nd-screen.png
macro.png
Active today
If I'm interpreting this correctly, it's not an error, but the user's Office settings for Trust Center is not allowing any Access apps that have code or macros to execute those code or macros, and when the AutoExec macro fires on startup it blocks execution.
Below is the manual answer for Access 2010. Also, afaik there is no way to programmatically pull this off, as this was intended to be a safeguard against viruses.
Give this a whirl on the pc that is generating the message (Access 2010)
(1) Go to File menu, Options. The Options window will appear.
(2) Click on the Trust Center on the left, and hit the 'Trust Center Settings...' button. The Trust Center window will appear.
(3) Click on Trusted Locations, then click on the 'Add new location...' button.
(4) Enter the path that the Access app lis in, and hit Ok.
(5) Hit Ok a couple of times to close.
Close out of Access, then open the database, and it should go straight to the Main Menu.
Below is the manual answer for Access 2010. Also, afaik there is no way to programmatically pull this off, as this was intended to be a safeguard against viruses.
Give this a whirl on the pc that is generating the message (Access 2010)
(1) Go to File menu, Options. The Options window will appear.
(2) Click on the Trust Center on the left, and hit the 'Trust Center Settings...' button. The Trust Center window will appear.
(3) Click on Trusted Locations, then click on the 'Add new location...' button.
(4) Enter the path that the Access app lis in, and hit Ok.
(5) Hit Ok a couple of times to close.
Close out of Access, then open the database, and it should go straight to the Main Menu.
Active today
This is caused by Office security settings. Since this appears to have begun several months ago, I assume that the version of Office in use on that computer was upgraded from 2003 or lower to 2007 or higher about two months ago.
The only way to circumvent this message is to designate the folder that the application resides in as a "trusted location". Creating a "trusted location" will allow VBA code (and macros) embedded in any Office application that resides in that folder to run without first having to "enable" macros.
1. Click the Office button in the upper left corner when Access is opened,.
2. Click the "Access Options" button (bottom center of popup window)
3. Click the "Trust Center" option in the panel on the left of the Access Options dialog
4. Click the "Trust Center Settings" command button
5. Click the "Trusted Locations" option in the panel on the left
6. Click the "Add a new Location" button, then migrate to the folder where your application resides.
HTH
Dale
The only way to circumvent this message is to designate the folder that the application resides in as a "trusted location". Creating a "trusted location" will allow VBA code (and macros) embedded in any Office application that resides in that folder to run without first having to "enable" macros.
1. Click the Office button in the upper left corner when Access is opened,.
2. Click the "Access Options" button (bottom center of popup window)
3. Click the "Trust Center" option in the panel on the left of the Access Options dialog
4. Click the "Trust Center Settings" command button
5. Click the "Trusted Locations" option in the panel on the left
6. Click the "Add a new Location" button, then migrate to the folder where your application resides.
HTH
Dale
Active today
>when I open the app with Shift key, I get this screen only
That's because opening it with the Shift key down bypasses the AutoExec macro.
Since no code is executing, it allows the file open, which then goes to a blank screen with all your objects listed.
That's because opening it with the Shift key down bypasses the AutoExec macro.
Since no code is executing, it allows the file open, which then goes to a blank screen with all your objects listed.
Active today
Sorry, Jim. Did not mean to repeat your post.
The other thing about the Shift bypass, if you look at your screen (not the image you posted), you should see a bar across the top of the Access window (probably right below the menu bar) that says something like:
Security Warning Certain content in the database has been disabled
This will be followed by a command button (Options) which pops up the Security Options dialog, which is the first image you provided.
The other thing about the Shift bypass, if you look at your screen (not the image you posted), you should see a bar across the top of the Access window (probably right below the menu bar) that says something like:
Security Warning Certain content in the database has been disabled
This will be followed by a command button (Options) which pops up the Security Options dialog, which is the first image you provided.
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database. This article shows how to recreate this functionality in Windows 7 through 10.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses
Course of the Month8 days, 9 hours left to enroll
764 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.