RE: Problem creating access Query on the fly
From: Jim Gamble (Gamble_at_discussions.microsoft.com)
Date: 12/27/04
- Next message: Frank Hickman [MVP]: "Re: Key column information insufficient....ERROR"
- Previous message: Matt Neerincx [MS]: "Re: Recordset.AddNew and the recordset object's data retaining"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 27 Dec 2004 05:25:02 -0800
I have noticed the same problem. I also found that by looping through all the
'Tables' in the database, some of the queries are found. Looping through
'Procedures' does not yield all of the queries. Looping through 'Views' finds
others.
Have you found an answer to this problem?
"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
>
>
- Next message: Frank Hickman [MVP]: "Re: Key column information insufficient....ERROR"
- Previous message: Matt Neerincx [MS]: "Re: Recordset.AddNew and the recordset object's data retaining"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
