Ok, after a lot of search, i finally found an almost perfect way to do the following from VB6 in an Access 2000 database:

- Delete a query using ADO (exclusivelly).
- Create a new query using ADO (exclusivelly) which unfortunatelly will NOT be visible from within Access 2000 interface.
- "Create" a new query using ADO (exclusivelly) which may be visible from within Access 2000 interface, depending on how you do the whole process.
- Alter a query's SQL statement using ADO (exclusivelly).

I'm describing the process below. I'm also posting the code i found, in my next post in this thread. Hopefully, my research will save someone's time...

Deleting the query is a rather easy process, without any workarounds. When creating a new query from within VB using ADO though, it is not visible in Access 2000. If you wish to bypass that, you can do the following:
- Create a dummy query from within Access 2000.
- Use the AccessQueryUpdate sub in my next post to modify the query's statement from within VB. Altering the query's statement does not render it invisible, only creating a new one does.

I hope this solution helps some people...