Accessing data from VB6 - Query builder's

[Paul Nockolds]

We have SQL Server 6.5 with an Access 8.0 front-end. We are about to re-write our front-end in VB6 using RDO. Obviously Access has a nice fast and easy to use query builder. My question therefore is - is there any such query builder that can be used within VB6 to simplify query writing ? Or do I have to write all query's and and stored procedures using straight SQL and/or stored procedures. I do not want to use Visdata as it doesn't appear up to the task.

Thankyou whoever helps

Paul

[Paul Nockolds]

On 1/7/99 9:37:52 AM, alan wrote:
> If you are going to us VB6 - There is a query tool available. Create a
> database project and use the data designers. After you establish a
> connection object then create a command object. Once the command ojbect is
> created the Query builder button should be available to you.

Another
> comment - Why use RDO - nothing wrong with it, but the present and the
> future belong to ADO. ( plus it is a simpler object model )

Hope this helps
Alan

I'll give it a go - thanks Alan
Thanks for the ADO tip as well.