RE: Problem creating access Query on the fly

From: AA2e72E (AA2e72E_at_discussions.microsoft.com)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 00:59:05 -0700

I have encounterd this problem too. The Query is not visible when you use the
JET provider to create it. Use the ODBC driver instead: if the query exists
(albeit hidden) the ODBC driver prompts for overwriting it.

"Ralph Boswell" wrote:

> 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: MS SQL Server/ODBC package for Python
    ... Running your benchmark, I ran into a couple of interesting points. ... I changed the query to ... If adodbapi avoids this (which we'll also integrate into mxODBC 2.1), then this would explain the differences you see. ... ODBC driver doesn't provide proper size information - each ...
    (comp.lang.python)
  • Re: ODBC driver manager mangles delimited column names
    ... Thanks Robert, I'm beginning to think you are right. ... I've just finished running some more tests with the trace logging turned on for the ODBC driver manager. ... This is what I get in the log for the automatically generated query: ...
    (microsoft.public.data.odbc)
  • Re: Accessing a paradox table from a C# application...
    ... SELECT TOP 1 * FROM ModelSer ORDER BY Timestamp ... How much faster is the query if you strip off the PX? ... The ODBC driver that I am using is the Microsoft Paradox ...
    (comp.databases.paradox)
  • Re: Informix+ODBC+ADO.NET - problem
    ... It is hard for me to imagine why any problem with a select query would ... the ODBC driver and your application is assuming that whatever went ... wrong was the same as a dead connection. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ODBC parameter query
    ... connecting to thru the ODBC driver, and the type of connection you're ... It sounds like you're using SQL pass-thru queries, ... Then use the query. ... > I have a set of foreign tables to query through a third party ODBC driver. ...
    (microsoft.public.access.queries)