Can I search M$ Access databases from Delphi?

[Tenchy]

Hi,

I need to be able to search through a database that is in Microsoft Access.

I hate the Access front end, so I'm wondering if I can create an app in Delphi that can interogate the Access DB and select which table and fields to search thru, and generate a list of hits?

I'm not into databases, so hopefully this can be done with some components or fairly easily?

 

[Opieo]

First off, this can most definitely be done.
There are many ways you can do this from Delphi.
You will need to either set up the BDE, or use ADO components.
An easy way is to use the ADO components in the dbGo component section (or equivalent for your version of Delphi). You are looking for the TADOConnection.
Once plopped onto your form, set up its connection string. This can be done manually, or by using the wizard that is in there for it.
You can also then set up a TADOQuery if you want to use the query to look for data.
Or you could set up TADODataset and TDBGrid or TDBNavigator.
I do not mean to brush you off in any way, but there are many other forum posts on all of these and setting them up, as well as FAQs in this very sub-forum.
I use ADO because it is really easy to set up and great for manipulating everything.

~
Give a man some fire, he will be warm for a day, Set a man on fire, he will be warm for the rest of his life.