How do I do a global field search?

[Frank Martin]

I have WinXP and Access2003.

I have just finished changing over a text
primary key "ProductID" to a autonumber
"ProdID".

This was successful, and all the database
(including the Combos and the xtab queries)
work OK.

But now I want to get rid of all the old Text
"ProductID" values and fields.

I have done this manually as far as possible,
but is there a "Find" function to locate all
the redundant "ProductID" all through the
database?

Please help
Frank

 

[mscertified]

No there is such thing built in.
You will have to do manual searches through all VB code, queries, forms etc.
Its possible to code a function to automate it but its not a trivial exercise.

-Dorian

 

[Frank Martin]

Thanks.



message

No there is such thing built in.
You will have to do manual searches through
all VB code, queries, forms etc.
Its possible to code a function to automate
it but its not a trivial exercise.

-Dorian