I have a application I developed in Access 2003. I recently upgraged to Access 2007. I am trying to update macros that backup and reloads my tables. It won't let me add a new RunSQL to the query. I looked at help it says this command is no allowed on non trusted databases. The database is in the trusted list. Not sure if I missed something or if this is a bug. Anyone have ideas or simular problems?
RunSQL not working
- Thread starter wjburke2
- Start date
Thanks Mr. Q, I went ahead and set the trusted location and run all macros to ok but it still did not show RunSQL in the list. But, I think I found the solution don't know how I missed it. Luckly I have MSDN guy that works next to me. On the design ribbon while in Macro edit mode one of the tabs says "Show All Actions" Click that and you get a bunch of new query actions including RunSQL. 
