I replicated this...

Interestingly, the only place in access where you can see the newly-
created query is in the security wizard...

Kind of implies it's some kind of permissions problem.

There's a special user called "engine".   Given there's no user ID in your 
connection, I wonder if the queries are being created with that owner, and 
don't have permisions for uses.

I'll take a look and see what I can come up with - it relates to some 
stuff I have to do shortly anyway.




> I am trying to create a query in an Access 2000 database in a VB6 
program.
> The code actually creates a query, but you can't see it in Access.  Has
> anyone got any ideas on where I'm going wrong.
> 
> Coral
> 
> Dim mcatDBCatalog  As New ADOX.Catalog
> Dim lcmdCommand As ADODB.Command
> 
>    'get catalog for database
>    mcatDBCatalog.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" _
>          & "Data Source=" & App.Path & "\db1.mdb;"
> 
>    Set lcmdCommand = New ADODB.Command
>    lcmdCommand.CommandText = "SELECT * FROM tblEmployee"
>    mcatDBCatalog.Views.Append "qryNew", lcmdCommand
>    mcatDBCatalog.Views.Refresh
> 
>    Set lcmdCommand = Nothing
>    Set mcatDBCatalog = Nothing
> 
> 
> ________________________________________________
> 
> JB DESIGN (CAIRNS) PTY LTD
> Building Design & Documentation
> Development Consultants
> AutoCAD & Database Software Sales & Support
> 
> PO Box 1744, Cairns QLD 4870, Australia
> 1st Floor, 192 Mulgrave Road, Cairns
> Tel +xx x xxxx xxxx
> Fax +xx x xxxx xxxx
> www.jbd.com.au
> ACN 056 308 153
> 
> Disclaimer
> This message and any attachments, may contain confidential information
> intended only for the addressee. Any unauthorised use of this material is
> prohibited. If you receive this message in error, please notify the 
sender
> immediately and delete this message from your computer network.
> Opinions expressed in this e-mail are those of the sender and do not
> necessarily represent the views of JB Design. JB Design does not accept 
any
> responsibility for the loss or damage that may result from reliance on, 
or
> the use of, any information contained in this e-mail.
> Permission is required from the sender to forward this e-mail or 
attachments
> to a third party.
>