Experts,
The Scenario
I have made some ASP pages for an access database with no problems. The aim was that users would no longer open the access database, but do everything via the webpages. However, I have just realised that there is a macro in the Access db that needs to be run.
The Macro
The macro runs an append query to an SQL Server db, and updates projects that staff can charge time too ( so is v.important!). updating the access database via the webpage means that this macro is not run.
Solution?
Is there a way i can call the macro from the webpage after a record is added? or can i write a new query as part of my ASPRunner project?
Thanks guys!
