You can drag/drop a shortcut from the database window to the desktop, but it
will open access to run it when you double click the desktop shortcut.
AFAIK, there's no way to run an access query without opening access.
If it helps at all, you could make a shortcut to a form, have the form's
OnOpen run a query, and then close the app (application.quit), but access
takes a minute to load anyway, and there's know way to keep it from showing
(that I know of) when you do this. Probably not a lot of help, but its an
option.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.