Access a query without opening Access

I have a db with several dozen queries. I need a non-technical person, who
is also not authorized to see all the info in the db, to run one query each
day.

Is there any way to launch a query without being in the query view of
Access? Or is there a way to have a single query in the query window whuch
has sub queries not visible or in another location?

On Fri, 8 Jan 2010 15:11:01 -0800, Tired and Confused Tired and
wrote:

I have a db with several dozen queries. I need a non-technical person, who
is also not authorized to see all the info in the db, to run one query each
day.

Is there any way to launch a query without being in the query view of
Access? Or is there a way to have a single query in the query window whuch
has sub queries not visible or in another location?

One way is to create a Macro (let's call it RunIt) that has two lines: one to
use the RunQuery action to execute the query (which should not have any
parameters), and then a Quit action to close the database.

You can open Access using either a shortcut or Windows Secheduler with a
command line such as

"C:\Program Files\Office\Office12\msaccess.exe" "E:\path\mydb.mdb" /x RunIt

The /x switch causes Access to open running that macro.

--

John W. Vinson [MVP]

John W. Vinson wrote in
:

On Fri, 8 Jan 2010 15:11:01 -0800, Tired and Confused Tired and
wrote:

I have a db with several dozen queries. I need a non-technical
person, who is also not authorized to see all the info in the db,
to run one query each day.

Is there any way to launch a query without being in the query view
of Access? Or is there a way to have a single query in the query
window whuch has sub queries not visible or in another location?

One way is to create a Macro

You could also write a VBScript that wouldn't even open Access at
all -- you'd just use DAO to execute the query in the database.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

You can run a saved query through VBA behind a form, with the VBA either
containing the SQL instead of a saved query, or having the VBA run the saved
query. You can do this from a different form than the one with the delicate
information. If using Access 2007, you use the wizard and create a macro,
then convert the macro to VBA, if needed.

"John W. Vinson" wrote:

On Fri, 8 Jan 2010 15:11:01 -0800, Tired and Confused Tired and
wrote:

I have a db with several dozen queries. I need a non-technical person, who
is also not authorized to see all the info in the db, to run one query each
day.

Is there any way to launch a query without being in the query view of
Access? Or is there a way to have a single query in the query window whuch
has sub queries not visible or in another location?

One way is to create a Macro (let's call it RunIt) that has two lines: one to
use the RunQuery action to execute the query (which should not have any
parameters), and then a Quit action to close the database.

You can open Access using either a shortcut or Windows Secheduler with a
command line such as

"C:\Program Files\Office\Office12\msaccess.exe" "E:\path\mydb.mdb" /x RunIt

The /x switch causes Access to open running that macro.

--

John W. Vinson [MVP]
.