How to Create Query/View in MS Access

R

Ritesh

Hi! All,

I am using VB 6.0 and MS Access 2000.

I want to create a program which updates database at client site.

That program needs to create a query. I have successfully create a query
through ADO using Create View command. But, the problem is the query is not
visible in MS Access Query tab ?!!

Interestingly, I have opened the database with VisData and the query is
there. Although, the query which are generated using the ADO contains lesser
properties than the query generated by MS Access.

Now, does this means that there is no way to create a query from front end
in MS Access 2000.

Please, reply as soon as possible..... urls / code snippets / etc. anything
which could be helpful.....


Thanks in Advance,
Ritesh.
 
J

John Vinson

Now, does this means that there is no way to create a query from front end
in MS Access 2000.
Click to expand...

Certainly not.

The Access Query object can be created using the CreateQueryDef
method. See the online help.

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using "like" query from and external link to Access 1
Can't create a report from my query in Access 1
MS Query 4
MS Access Query Design Question 0
DBF linked on ACCESS Query 1
How to run a "query" form a MS-DOS Batch 4
Can't drag in drop to create a query 0
MS Excel TO MS Access 7

Top