Check for dependencies, before deleting field from table

J

jsccorps

I want to delete a field from a table (i don't thing that it was ever used).
Is there a routine that I can run that checks if any objects (e.g., query,
form, report) depend on this field? Don't want to delete the field and then
find out later of dependencies.
 
T

Tom Wickerath

I use SpeedFerret for this, however, this tool is not free:

Speed Ferret: http://www.moshannon.com/speedferret.html

Of the two tools listed below, I think one of them is free, but I have no
experience using either one of them:

Find & Replace: http://www.rickworld.com/products.html
Ucora: http://www3.bc.sympatico.ca/starthere/findandreplace/

The tool should also detect for any references in VBA code (or you should
search your project for any references, just to be on the safe side).
SpeedFerret does all of this.

Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
Top