Access: save query as an application

  • Thread starter Thread starter Lieb
  • Start date Start date
L

Lieb

How can I save an access query as an application so that I can use this
application as part of a batch file? The batch file will be used on a
computer that is not equipped with Access due to data security reasons.
Therefore, the direct SQL language from the query cannot be used. The
application would have to have only the components of access that are
necessary to perform the query. Queries I will use include select, update,
append, and delete.

Thanks
 
How can I save an access query as an application so that I can use this
application as part of a batch file? The batch file will be used on a
computer that is not equipped with Access due to data security reasons.
Therefore, the direct SQL language from the query cannot be used. The
application would have to have only the components of access that are
necessary to perform the query. Queries I will use include select, update,
append, and delete.

Thanks
Click to expand...

You cannot.

Access queries do not exist independent of the Access program.

You can install the Access Runtime on this machine but if you want to use
Access features such as update queries... you need the Access programs.

It's sort of like saying you want the pickup truck but don't want to have an
engine installed in it.
 
Back
Top