access macro question

[bob]

I was given an access db and have to convert it to sql server.
I'm trying to figure the updates done in this application by looking at
the macros and queries but every macro I look at references a query that
doesn't seem to exist. Yet the macros run ok. I just can't seem to
locate the source for the queries. Can anyone shed some light on what
may be happening here?
Thanks

 

[John Vinson]

I was given an access db and have to convert it to sql server.
I'm trying to figure the updates done in this application by looking at
the macros and queries but every macro I look at references a query that
doesn't seem to exist. Yet the macros run ok. I just can't seem to
locate the source for the queries. Can anyone shed some light on what
may be happening here?
Thanks

No, not without seeing the text of the macros.

John W. Vinson[MVP]

 

[Guest]

It sounds like the person who created the original ACCESS db may have hidden
these queries from public view.
====================