Does Microsoft Access have Full Text Search?

views:

1406

answers:

+6 Q:

Does Microsoft Access have Full Text Search?

I know that MySQL and SQL Server have Full Text Search, but I am not too certain on Access.

If Access doesn't have Full Text, what is the best alternative to achieve the same objective of Full Text Search?

Thanks

+3 A:

I'm not 100% certain, but the fact that this site from Microsoft doesn't mention Access suggests to me that the answer is "no".

My gut reaction would also be "no". Access wasn't intended to be the ne plus ultra in relational database technology. If it were, there'd be no reason for SQL Server.

duffymo 2008-12-30 02:51:14

MSDE (now called Sql Server Express) has full-text indexing, if you're looking for a client-deployable database

Steven A. Lowe 2008-12-30 03:37:48

if access haven't fulltext search, so what is best search for access?

cuipap 2010-07-28 00:32:15

Depends on the context in which you want to search.

David-W-Fenton 2010-07-30 21:42:04

Access is not a database. But it does ship with a default database engine, Jet/ACE. I would assume that's what you mean, but you should be more clear what you mean when you ask a question like this.

Jet/ACE does not have any full-text search capabilities.

The best way to do full-text search of Jet/ACE data files is through whatever full-text search capabilities you have for files on your computer. This is not going to be fast, nor is it going to be usable via SQL.

You don't say what context this is, but I have in general never seen a need for full-text search except on websites (where it's something of an expected capability). If you're using Jet/ACE as the datastore for an HTTP application, then you've chosen the wrong data store. While Jet/ACE can work fine for low-volume read-only websites, that's not an advisable usage (because of limitations in the Jet/ACE database engine).

If you need full-text searching then you need a different database engine.

David-W-Fenton 2010-07-28 19:18:15

Access is a DBMS with a development platform bolted on (VBA, Access Forms and Reports). An Access file can be a database, but not necessarily. Unless you state these things, your post is only going to confuse new users, and not help them develop their understanding of the product, given that Access is generically referred to as a database. In the same way, SQL Server is not a database but a DBMS. The difference, in terms of what its files represent, between SQL Server and Access is that SQL Server files are always database files.

awrigley 2010-10-26 08:32:10

@awrigley: how is your comment anything other than just restating what I said in my answer? I'm quite clear in my answer that I'm talking about the Jet/ACE database engine. There is no ambiguity at all in what I wrote. You really should reverse the downvote, as your comment is just gibberish.

David-W-Fenton 2010-10-26 20:14:30

A newcomer to Access reads an answer that says Access isn't a database, but the comment doesn't expand on what Access is except in acronyms? That is gibberish to a newcomer. The downvote stands, not just because your comment is puerile.

awrigley 2010-10-26 20:37:20

You say my comment restates what you say then you say my comment is gibberish. Make your mind up. My comment restates what you say in a way that might just help the kind of person asking this question. Which is what SO is all about.

awrigley 2010-10-26 20:42:01

Part of your comment is not gibberish, i.e., the part that repeats what I said. What follows that is gibberish.

David-W-Fenton 2010-10-27 20:51:47

Last of all, where's *your* answer? If you feel the existing answers are incomplete, then the usual response to that is not to downvote those answers for being incomplete, but to post your own answer that supplies the missing information. Anything else is pretty damned childish.

David-W-Fenton 2010-10-27 20:52:46

ansaurus

tags:

views:

answers:

Does Microsoft Access have Full Text Search?

related questions