🚀 go-pugleaf

Hi there!

you may find the ODBC Driver provided by Openlink useful to provide
you with ODBC connectivity to the Access database in question.

Although Access does have an ODBC Driver, you may find that it does
not meet your requirements for example should you want ODBC
connectivity across a network or from a non windows based machine.

Using the OpenLink ODBC Driver suite will allow you to connect through
the Access Driver but from non windows based O/S's and across a
network.

Have a gander at http://www.openlinksw.com for free evaluation, fully
functional drivers

HTH

BR

John


"Shaun" <nospam@nospam.com> wrote in message news:<3d3ab34f_1@dnews>...
> Hi,
> 
> Theres a few ways to do it, heres one way with odbc.
> 
> Make an ODBC Connection to your Access Database
> 
> Then open builder and drop a TQuery, TDBGrid, TDatasource on a form.
> 
> In the Object Inspector make these settings,
> 
> Datasource1->Dataset = Query1
> DBGrid1-DataSource = DataSource1
> Query1->DatabaseName = [SELECT FROM THE COMBOBOX, YOUR ODBC ALIAS FOR YOUR
> ACCESS DATABASE]
> Query1->Sql [double click on (TStrings)] and in the String List editor Type:
> select * from [table1] or whatever SQL statement that is relevant for you.
> 
> Query1->Active = true.
> 
> Your database should appear in your DBGrid at design time.To edit the column
> widths right click on the DBGrid and select "Columns Editor" Right click,
> select add all fields, then select a specific field and alter it in the
> Object Inspector.
> 
> Hope this helps
> 
> regards Shaun