97 to 2003 missing queries

D

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
 
D

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
 
A

Allen Browne

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