Find a word in whole database (1 Viewer)

[Just1]

I know you can find and replace within a datasheet or field, etc, but are you able to search the whole database, ie. all the different tables to find a particular word? Or would I need to set up a query to include all the fields from all the tables and then search that in the usual way?

Thanks
Just1

 

[Blou]

Hi I had the same question.....
There is 2 ways on doing it:1 Concatenate all your data into a memo field.2 write a query with a Like*()*--(your word you are looking for) statement, but the last one can become complicated if you have to many field's to look in.

Hope it helps you, It worked for me

Blou