Problem creating access Query on the fly

From: Ralph Boswell (rb-nospam_at_bgi-sa.com)
Date: 09/28/04 

Date: Tue, 28 Sep 2004 18:18:42 +0200

Hi,

Maybe this is a well known problem so maybe you can help.
 From Visual Basic, I would Like to create a query in an Access database
via ADO/ADOX.
The problem is that the query seems to be correctly created but is not
visible in access interface. I read somewhere that the query was visible
through code and once it existed, even if not visible, it was usable.
OK, no problem (even if it is annoying in access interface) if i know
that the query is there. A further problem is then that if I write a
procedure testing the presence or not of the query by looping on the
tables/views name, I cannot see the query and my procedure returns a
false value as it didn't find the query. If I run then a procedure to
create the query, an error occurs saying that the query exists....

Any help on that subject?

Thanks in advance.

Ralph

Relevant Pages

  • RE: query with wildcard, etc
    ... JET back-end or some other database engine? ... Are you using the Access interface to run the Query or by code? ... ADO code or DAO code? ...
    (microsoft.public.access.queries)
  • adp project delete my data
    ... Right click on the record and Filter by selection using Access interface. ... I do not have any query to run it, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Migrating Problem Word 2000 to Word 2003
    ... > the query is run in the Access interface. ... This means a DDE connection. ... or read a number of posts here) ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Bitwise AND in Access query
    ... only if you run the query under ADO code. ... The Access interface uses DAO, ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.queries)
  • RE: Problem creating access Query on the fly
    ... Use the ODBC driver instead: if the query exists ... "Ralph Boswell" wrote: ... no problem (even if it is annoying in access interface) if i know ...
    (microsoft.public.data.ado)