Automatically run query when new/edited record is saved

[Ed Moss]

I'm working with an ASP - Access 2000 web application that manages
shipping information for a client, and need to make some changes to
it:

My client's label printing program can pull from an OLE DB source, but
is limited to only one table. The main table that the site uses stores
key values from a lookup table (ID,Name) for 4 of the 8 fields that
need to be printed, so I need a mechanism where a single table can be
created to make the Name values available to the label program.

I created the relationships and query needed to display the 8 fields
info, but need to modify this so the following occurs:

What is required so that the query automatically creates a new table
whenever a new/edited record is entered on my main table?

Thanks,

Ed Moss

 

[[MVP] S. Clark]

On the Action Page of the Form, you can add code to execute the Make Table
Query. So, when the user presses a button on the ASP form, trigger the SQL.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-