Solved

MS Access 2007 cannot add RunSQL step to macro

Posted on 2010-08-13
6
1,359 Views
Last Modified: 2013-11-27
I am trying to build a macro in Access 2007 and one of the steps I'd like to add is the RunSQL step.  It is not available in the list of Actions.  I've read this might be related to Trust Center settings.  I verified the location of this db is in a trusted directory, which happens to be my desktop.

Does that have anything to do with it or am I looking at the wrong issue?  
0
Comment
Question by:bsncp
[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
  • 3
  • 2
6 Comments
 
LVL 75
ID: 33432771
You can do it in code

Dim sSQL As String
DoCmd.RunSQL sSQL

mx
0
 

Author Comment

by:bsncp
ID: 33432810
Thanks, mx.  But I'm looking to build a multi-step macro, of which this RunSQL action will be just one step.  I like being able to add RunSQL as a step in the macro and trhen type my SQL statement right in.  

Is RunSQL not anoptional action in Access 2007 macros or is in fact some sort of Trust Center issue?  I am used to 2003, so just trying to understand the nuances of 2007.
0
 
LVL 75
ID: 33432837
Well, I don't know.  My A2010 system is at home.
But I've got to believe it's there somewhere, maybe under a different category ...?

mx
0
Office 365 Training for Admins

Learn how to provision tenants, synchronize on-premise Active Directory, and implement Single Sign-On with these master level course.  Only from Platform Scholar

 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 250 total points
ID: 33432847
Right click on the header of the macro.  You should see an option that reads: Show All Actions.

Select that option and RunSQL will showup.
0
 

Author Comment

by:bsncp
ID: 33432868
Not sure what you mean by category, but when building a macro, you only get to choose from one drop-down menu of Actions.  RunSQL is an option in 2003 but not in 2007 so far.  My research on the web says it is Trust Center related, so I need help from someone who understands that piece of it.
0
 

Author Closing Comment

by:bsncp
ID: 33432885
Very well done...thank you!!
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question