You must run Access' VBA from an Access database, and, for what you want to
do, that may be pretty high overhead -- but if that isn't an issue, read
ahead. You could write similar code in the separate ("classic") VB 6 product
that would have a much smaller footprint. In either case, there is a way to
have particular code run at startup. You'll need to use the Windows
scheduler, or a third-party scheduler, to initiate execution of your
application on a particular schedule.
Other products support VBA, but you wouldn't be any better off running it
from Excel, or Word, or one of the other software packages where it can run.
VBA does not have an option for a compiled, standalone execution.
Larry Linson
Microsoft Access MVP
"Dan Hicks" <da**********@hotmail.com> wrote in message
news:e4**************************@posting.google.c om...
Hi,
I wrote this test code as part of a module I created for the Northwind
database. However, I was only using this as a test platform. My goal
was to write a program that would take records from SQL server and
import them into the outlook address book. It worked, great.
Now I'd like to run this VBA code independent of the Northwind
database. Understand that I don't have the first idea of what program
I can use to run this VBA code as a standalone module. I'd also like
the program to be able to run on its own power, on a schedule, without
me telling it to run everytime.
Any ideas?