Running an Access Query from ASP
I'm an admitted newbie when it comes to running Access and ASP together. I have managed to create a few simple queries to go from ASP, but I've got a more complex query already created in access that I would like to be able to execute from ASP.
So, I guess my questions are:
1) How do I do it?
2) Is there a way to, for lack of better phrasing, "copy and paste" the query SQL into an asp page? If so, what do I need to look for?
Some additional information:
I'm doing this with ADODB so far. My driver has been Microsoft Access Driver. I could provide more information if people need it.
Thanks in advance for any help that I can get.