Odd Dependencies Question

Nov 16, 2006

I've got several queries, forms and reports in my database, and I've just noticed that when I look at Object Dependencies, 3 of the queries appear to be depending on the wrong forms. However when I check the SQL of each of these queries, the code definitely is referring to the correct forms.

However can this be and how do I sort it out? All I can think is that when I created these queries originally, I did do a copy and paste from another query and then manually editted the SQL to refer to correct form. Would this cause something to get missed?

Thanks.

View Replies


ADVERTISEMENT

Inter MDB Dependencies

Mar 27, 2006

1.Can we have two table in two MDBs with a foreign Key Relationship.
2.Can we Rollback in Access

View 1 Replies View Related

Report That Shows Query Dependencies

Jan 8, 2012

I have a database that reuses many queries in several different macro's. Any way to generate a report, (or purchase an add-in), that will show for each query any other queries that use it. It would be ideal to show all of the "cascading" queries that one query is built on. It just gets confusing when I need to tweak a query to then have to figure out there are other queries that use the one that's being tweaked and the tweak will change the results of the other queries.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved