Re: Search a word in whole database

Article View: comp.databases.ms-access

Article #206

Back to comp.databases.ms-access Previous Next

#206

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

Technical Details

Message-ID: <OMla59BDEHA.3408@tk2msftngp13.phx.gbl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!enews.sgi.com!msrnewsc1!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl

References: <INX5c.150470$Ae1.2607207@weber.videotron.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,3e0143119d4c2147
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 11387c,3e0143119d4c2147
X-Google-Attributes: gid11387c,public
X-Google-Thread: 10bb27,3e0143119d4c2147
X-Google-Attributes: gid10bb27,public
X-Google-ArrivalTime: 2004-03-17 05:00:45 PST
From: "Jeff Boyce" <JeffBoyce_IF@msn.com-DISCARD_HYPHEN_TO_END>
References: <INX5c.150470$Ae1.2607207@weber.videotron.net>
Subject: Re: Search a word in whole database
Date: Wed, 17 Mar 2004 05:01:19 -0800
Lines: 19
MIME-Version: 1.0
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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: <OMla59BDEHA.3408@tk2msftngp13.phx.gbl>
Newsgroups: comp.databases.ms-access,dk.edb.database.ms-access,microsoft.public.access.queries
NNTP-Posting-Host: c-24-18-56-4.client.comcast.net 24.18.56.4
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!enews.sgi.com!msrnewsc1!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl

Reply to Parent Message