To Call a Macro or Not Call a Macro that is the question?
Posted on 2008-10-07
I have two databases, one that is a Access database located on the webserver and another that is a dbase database on a remote machine. I have an ODBC to both. I have created a query that will copy the data from a table in the dbase database and copy the contents to a Access table. I would like to to trigger this copy from a webpage, now I know I can have the webpage copy the data over but as the table gets bigger it will take longer to copy the data over. The query seems pretty quick at doing this. Should I have the query called from a Macro and call the Macro from a ASP page or is there an easier way? Ideally I would like it so when a person goes to the page I have a query that checks both tables and if they are not the same to have it delete the data from the Access table and Copy over the data from the DBase table for it will be accurate. I have tried:
Set acs = CreateObject("access.Application")
Set acCmd = acs.DoCmd
But I get:
Microsoft VBScript runtime error '800a0046'
Permission denied: 'CreateObject'