Hello All...<br>
<br>
I'm an experienced Network Admin, but an Access beginner. I have a question, is it possible to link two more more queries together to perform functions in sequence? Here's my dilemma:<br>
<br>
We are using an Access DB to store 800#'s that our company uses. Our Telecom team would like to use this from our Intranet site, which I've agreed to take on. They want the database to be able to back up records that are being modified, essentially creating a "history" table of all records that have been changed.<br>
<br>
I'm able to do this by creating a "modified" date field in the main table and then performing an append query based on the date to a history table. I can get this to work using a macro, but I'm not sure if it's possible to run those from a web page. Any suggestions/ideas? Thanks much in advance!!!
<br>
I'm an experienced Network Admin, but an Access beginner. I have a question, is it possible to link two more more queries together to perform functions in sequence? Here's my dilemma:<br>
<br>
We are using an Access DB to store 800#'s that our company uses. Our Telecom team would like to use this from our Intranet site, which I've agreed to take on. They want the database to be able to back up records that are being modified, essentially creating a "history" table of all records that have been changed.<br>
<br>
I'm able to do this by creating a "modified" date field in the main table and then performing an append query based on the date to a history table. I can get this to work using a macro, but I'm not sure if it's possible to run those from a web page. Any suggestions/ideas? Thanks much in advance!!!
