Find ALL references to deleted field?

[Ann Scharpf]

Hmm ... I seem to have done a very dumb thing here. I have two related tables:

VendorFundedHrs
EmployeeVendorAssignment

The key to the VendorFundedHrs (ProjectCode) was a longish alphanumeric
string which I thought would be unwieldy to work with. So I created another
three-digit field, VendorID, which I added to both tables.

Then I linked the tables the way I SHOULD have in the first place ... with
the ProjectCode.

I THOUGHT I went through the database and found all queries etc that
referenced the VendorID field and changed them to reference the ProjectCode.
I then deleted the VendorID field from the two tables.

Apparently, I am not the sleuth I thought I was! I am stumbling across a
fair number of queries that now don't work because of the deleted field.

I saw references to the following in similar questions:

Download a copy of Rick Fisher's "Find and Replace" utility.
http://www.rickworld.com/download.html

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace (BTW, bad link now)
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

However, I work in one of those locked down "desktop management"
environments where you need an Act of Congress to get permission to load
something new on your machine. There is this insane vetting process that
takes FOREVER to get something new checked out & approved ... and they will
only even look at it if a bunch of people want it.

SO, is there a way using only Access functionality – even if it's more
tedious than these applications – to find all references to VendorID in the
database so that I can fix them?

As always, thanks so much for your help.

 

[Ann Scharpf]

I ended up just running every query in my database to see which ones failed.
I'd still like to know the answer to this question for future reference,
though.

Thanks!

 

[Allen Browne]

Ann, this one you can just run within Access, nothing else to install:
Where is a field used? - Search tables, queries, forms, and reports
at:
http://allenbrowne.com/ser-73.html

 

[Ann Scharpf]

Thank you so much, Allen! I'm bookmarking this so I'll be able to reference
it in the future, too.

 

[wal50]

A great help.
Thanks
wal50

Ann, this one you can just run within Access, nothing else to install:
Where is a field used? - Search tables, queries, forms, and reports
at:
http://allenbrowne.com/ser-73.html