Here's the scenario. Using a campaigning applicaion for an
eNewsletter. It writes to an Access table. I have an ASP web page that
writes to another table. I chained 3 Access queries together into a
Macro to copy that data to the campaigning table, give a numeric
identifier to that record, and then delete all records with that
identifier (in the 2nd table). This will keep the ASP > Access table
clean.
The campaigning software allows for a pre-processing SQL command to
be run. I would like to automate the updating of the table by
initiating this Access Macro from the SQL command. Anyone have any
ideas on the command/syntax?
Thanks in advance
Jason
JL*******@nyc.rr.com