Find ALL references to deleted field?

  • Thread starter Thread starter Ann Scharpf
  • Start date Start date
A

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
Click to expand...
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
Click to expand...

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.
 
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!
 
Thank you so much, Allen! I'm bookmarking this so I'll be able to reference
it in the future, too.
 
Back
Top