Search a word in whole database

Article View: comp.databases.ms-access

Article #205

Back to comp.databases.ms-access Previous Next

#205

From: 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.

Technical Details

Message-ID: <INX5c.150470$Ae1.2607207@weber.videotron.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!logbridge.uoregon.edu!newspeer.monmouth.com!newsfeed.yul.equant.net!c03.atl99!news.usenetserver.com!wesley.videotron.net!weber.videotron.net.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11387c,3e0143119d4c2147,start
X-Google-Attributes: gid11387c,public
X-Google-Thread: ff0ac,3e0143119d4c2147,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 10bb27,3e0143119d4c2147,start
X-Google-Attributes: gid10bb27,public
X-Google-ArrivalTime: 2004-03-17 04:47:43 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!logbridge.uoregon.edu!newspeer.monmouth.com!newsfeed.yul.equant.net!c03.atl99!news.usenetserver.com!wesley.videotron.net!weber.videotron.net.POSTED!not-for-mail
From: "Nik" <tnicolas@videotron.ca>
Newsgroups: comp.databases.ms-access,dk.edb.database.ms-access,microsoft.public.access.queries
Subject: Search a word in whole database
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <INX5c.150470$Ae1.2607207@weber.videotron.net>
Date: Wed, 17 Mar 2004 07:47:35 -0500
NNTP-Posting-Host: 69.70.28.216
X-Complaints-To: abuse@videotron.ca
X-Trace: weber.videotron.net 1079527656 69.70.28.216 (Wed, 17 Mar 2004 07:47:36 EST)
NNTP-Posting-Date: Wed, 17 Mar 2004 07:47:36 EST