Search a word in whole database

Thread View: comp.databases.ms-access

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Nik Wed, 17 Mar 2004 12:47

#205

Author: Nik
Date: Wed, 17 Mar 2004 12:47

20 lines
1734 bytes

Hi, I'm trying to search a word in all fields of all tables in a database.
Is it possible to get such a query?


Table1
fields1 ----- fields2 ----- fields3

Table2
fields1 ----- fields2 ----- fields3 ----- fields4 ----- fields5

Table3
fields1 ----- fields2

The word I'm searching may be in Table1-fields1 AND/OR Table2-fields3 AND/OR
Table3-fields1 AND/OR etc...
So I would like to get the ID (which is AutoNumber in each table) of the
record where the word is.

Thank for your help.
Nik.

Re: Search a word in whole database

#206

Author: Jeff Boyce
Date: Wed, 17 Mar 2004 13:01

18 lines
1666 bytes

Nik

So, if I tell you that the AutonumberID is 12345, how does that help you?
Which table is it in?  Which field in that table?

When I see a request to "search everything for a word", I suspect that the
database is a copy of a spreadsheet.  I'll suggest that your data structure
is probably in need of serious normalization, but I don't have much
information to go on.

More info, please ... as in "what's being stored in all these tables, in all
these fields?

-- 
Good luck

Jeff Boyce
<Access MVP>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads