I need to know how to access query

[mdctsg]

I am trying to access a query in access 2000. Tables are ok I just need to access the query and send to flex grid to view results. If someone would show me the code I would be greatful

Thanks
Bob

 

[LazyMe]

I think you can access queries in Access with the ADO command object, just like you would access a stored procedure in for example SQL server.


Greetings,
Rick

 

[mdctsg]

Thanks for the reply. I was having trouble and figured out I wasn't putting [ ] around the query name since it had spaces in it