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.
--
Jack Leach
www.tristatemachine.com
- "First, get your information. Then, you can distort it at your leisure."
- Mark Twain
