97 to 2003 missing queries

[dschl]

Someone is eating my queries.

When I open my '97 Access database in VB using ADO/Jet4 OleDB, I lose
many of the queries. They just disappear from the Procedures
collection.

Has anyone else seen this? How do I turn off the magic?

Any thoughts?

Thanks,
-Dave

 

[Allen Browne]

Are they in the Views collection?

 

[dschl]

Good call. Allen. I certainly didn't expect to find them there, but
they are.

Now, where do I find what the criteria is for selection into the views
as opposed to the procedures collection?

Thanks for the insight.

-Dave

 

[Allen Browne]

Very broadly, action queries and those with parameters are procedures,
whereas basic SELECT queries are views.