Trigger Access query via ADO in VBS file

[Irwell]

Hi everyone... I have a VBS script file which is used to perform scheduled tasks against data in an Access database. The machine the script is installed on has only got the runtime version of Access on it. Is there an easy way to call a query contained within the database from the VBS script via ADO? At present I am executing the SQL directly from the script, but I want to be able to modify the SQL from in Access and have the new version trigger without having to go in and edit my VBS file. I'm sure it should be fairly simple to achieve and I know how to do it from inside Access with VBA, I just can't seem to find similar functionality in ADO.

Any help would be much appreciated!

Edit: I know how to do it through DAO, but I don't want to have to rewrite the whole script.

[June7]

Not really understanding what you are asking for. You have a working VBScript? Why would modifying SQL (a query?) require editing the VBScript? Why would converting to DAO require a lot of modification in the VBScript?

Could you post the VBScript code?

[Irwell]

Unfortunately I can't post the code as I don't have access to it at the moment. I am working with a VBScript with SQL hard coded into it to save the recordset into another table in the database (my extract query from my previous question in one scenario). I have a query built into the database itself which performs exactly the same SQL, but I'm not sure how to trigger that query via ADO. I know I can trigger it via DAO but the script does a fair bit of additional manipulation and to be honest I'd rather not rewrite it.