CODEWITHSUNDEEP
ms-accessasp-classic
Zephram
Zephram

Reputation: 499

Triggering an mdb query on server

I have a Microsoft Access MDB file on a website to which an ASP classic code adds rows.

How do I create a query/module that will run every time I add a row or automatically once a day?

Upvotes: 0

Views: 245

Answers (1)

AnonJr
AnonJr

Reputation: 2757

If you're looking for something to run when a row is added, you're looking for "triggers" - which is not available in Access*. You find that sort of thing in proper RDBMSs like SQL Server, MySQL, etc.

If you're looking for something to run once a day, you could create a small VBS/PowerShell/etc. script and set up a scheduled task on the server to run it at an appropriate time.

You could also run the query in response to a page. If this is something that you want done after insert, then you can append the appropriate code to the end of the page or have it run as a part of the "success" page (if you have one).

* Unless you are using a .accdb (Access 2010 and later) file and the appropriate drivers. Then it appears you can use Event-Driven Data Macros to get the same effect. Thank you Gord Thompson.

Upvotes: 3

Related Questions