Full Text Search in MDB Blobs? "Christoph Müller" <cmueller[ at ]community.nospam> 07.02.2006 09:55:02 Hi! We are developing an application that archives files. The files are stored in mdb-Databases in Blob(Binary)-Format. Now the customers want to do a full text search. Is there a possibility to do a full text search on blobs in MDB Databases? The programming language is VB6. Thank you for your answer! Sincerely, Ch. Mueller AIB Informatik AG info[ at ]aibinformatik.ch

Re: Full Text Search in MDB Blobs? John Nurick <j.mapSoN.nurick[ at ]dial.pipex.com> 07.02.2006 20:02:32 Hi Christoph, As far as I know there's no simple way to do this. Certainly Jet doesn't offer anything like the full-text search facilities of SQL Server. Ordinary queries don't have access to the contents of OLE (blob) fields. Possibly you could store the contents of your files in Memo rather than OLE fields; that would at least provide a slow, stupid, sequential search through the raw contents of the files, if that's worth having. On Tue, 7 Feb 2006 10:55:02 +0100, "Christoph Müller" <cmueller[ at ]community.nospam> wrote: [Quoted Text] > >Hi! > >We are developing an application that archives files. The files are stored >in mdb-Databases in Blob(Binary)-Format. Now the customers want to do a full >text search. Is there a possibility to do a full text search on blobs in MDB >Databases? The programming language is VB6. > >Thank you for your answer! > >Sincerely, >Ch. Mueller >AIB Informatik AG > >info[ at ]aibinformatik.ch > > -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email.

Re: Full Text Search in MDB Blobs? "Christoph Müller" <cmueller[ at ]community.nospam> 08.02.2006 08:18:44 Hi John! Thank you very much for your answer! That's the thing i thought... I spent 2 days searching on this topic... Will it be possible with using Microsoft SQL Server 2005 instead of Access Databases? Sincerely Christoph "John Nurick" <j.mapSoN.nurick[ at ]dial.pipex.com> schrieb im Newsbeitrag news:7tuhu15o372h4r387i39vnr4sk2951e2h4[ at ]4ax.com... [Quoted Text] > Hi Christoph, > > As far as I know there's no simple way to do this. Certainly Jet doesn't > offer anything like the full-text search facilities of SQL Server. > > Ordinary queries don't have access to the contents of OLE (blob) fields. > Possibly you could store the contents of your files in Memo rather than > OLE fields; that would at least provide a slow, stupid, sequential > search through the raw contents of the files, if that's worth having. > > > On Tue, 7 Feb 2006 10:55:02 +0100, "Christoph Müller" > <cmueller[ at ]community.nospam> wrote: > >> >>Hi! >> >>We are developing an application that archives files. The files are stored >>in mdb-Databases in Blob(Binary)-Format. Now the customers want to do a >>full >>text search. Is there a possibility to do a full text search on blobs in >>MDB >>Databases? The programming language is VB6. >> >>Thank you for your answer! >> >>Sincerely, >>Ch. Mueller >>AIB Informatik AG >> >>info[ at ]aibinformatik.ch >> >> > > -- > John Nurick [Microsoft Access MVP] > > Please respond in the newgroup and not by email. >

Re: Full Text Search in MDB Blobs? John Nurick <j.mapSoN.nurick[ at ]dial.pipex.com> 08.02.2006 20:45:47 Hi Christoph, SQL Server has had full text search for years, though I'm not familiar with its capabilities. However, I don't know whether full text indexing is available in the free SQL Server 2005 Express, or just in the expensive versions. On Wed, 8 Feb 2006 09:18:44 +0100, "Christoph Müller" <cmueller[ at ]community.nospam> wrote: [Quoted Text] > >Hi John! > >Thank you very much for your answer! > >That's the thing i thought... I spent 2 days searching on this topic... > >Will it be possible with using Microsoft SQL Server 2005 instead of Access >Databases? > >Sincerely >Christoph > > >"John Nurick" <j.mapSoN.nurick[ at ]dial.pipex.com> schrieb im Newsbeitrag >news:7tuhu15o372h4r387i39vnr4sk2951e2h4[ at ]4ax.com... >> Hi Christoph, >> >> As far as I know there's no simple way to do this. Certainly Jet doesn't >> offer anything like the full-text search facilities of SQL Server. >> >> Ordinary queries don't have access to the contents of OLE (blob) fields. >> Possibly you could store the contents of your files in Memo rather than >> OLE fields; that would at least provide a slow, stupid, sequential >> search through the raw contents of the files, if that's worth having. >> >> >> On Tue, 7 Feb 2006 10:55:02 +0100, "Christoph Müller" >> <cmueller[ at ]community.nospam> wrote: >> >>> >>>Hi! >>> >>>We are developing an application that archives files. The files are stored >>>in mdb-Databases in Blob(Binary)-Format. Now the customers want to do a >>>full >>>text search. Is there a possibility to do a full text search on blobs in >>>MDB >>>Databases? The programming language is VB6. >>> >>>Thank you for your answer! >>> >>>Sincerely, >>>Ch. Mueller >>>AIB Informatik AG >>> >>>info[ at ]aibinformatik.ch >>> >>> >> >> -- >> John Nurick [Microsoft Access MVP] >> >> Please respond in the newgroup and not by email. >> > > -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email.

Re: Full Text Search in MDB Blobs? <david[ at ]epsomdotcomdotau> 06.04.2006 23:14:32 You can connect Access to SQL Server. However, even if you get a version of SQL Server with text indexing, I think the text indexing only works on text fields - not on binary documents. (but you need to ask that question in a SQL Server group) If you want full text search on Word or PDF documents, I think you will need to either (a) save a text version with the document version or (b) save the documents outside the database, so that Index Server (part of MS WebServer) can index them - I don't think Index Server will index blobs in a database (but you should ask that question in an Index Server group) (david) "Christoph Müller" <cmueller[ at ]community.nospam> wrote in message news:u6t%23KhILGHA.1760[ at ]TK2MSFTNGP10.phx.gbl... [Quoted Text] > Hi John! > > Thank you very much for your answer! > > That's the thing i thought... I spent 2 days searching on this topic... > > Will it be possible with using Microsoft SQL Server 2005 instead of Access > Databases? > > Sincerely > Christoph > > > "John Nurick" <j.mapSoN.nurick[ at ]dial.pipex.com> schrieb im Newsbeitrag > news:7tuhu15o372h4r387i39vnr4sk2951e2h4[ at ]4ax.com... > > Hi Christoph, > > > > As far as I know there's no simple way to do this. Certainly Jet doesn't > > offer anything like the full-text search facilities of SQL Server. > > > > Ordinary queries don't have access to the contents of OLE (blob) fields. > > Possibly you could store the contents of your files in Memo rather than > > OLE fields; that would at least provide a slow, stupid, sequential > > search through the raw contents of the files, if that's worth having. > > > > > > On Tue, 7 Feb 2006 10:55:02 +0100, "Christoph Müller" > > <cmueller[ at ]community.nospam> wrote: > > > >> > >>Hi! > >> > >>We are developing an application that archives files. The files are stored > >>in mdb-Databases in Blob(Binary)-Format. Now the customers want to do a > >>full > >>text search. Is there a possibility to do a full text search on blobs in > >>MDB > >>Databases? The programming language is VB6. > >> > >>Thank you for your answer! > >> > >>Sincerely, > >>Ch. Mueller > >>AIB Informatik AG > >> > >>info[ at ]aibinformatik.ch > >> > >> > > > > -- > > John Nurick [Microsoft Access MVP] > > > > Please respond in the newgroup and not by email. > > > >