How to connect Database component to Ms Acces (mdb) database

[katran]

Did enybody tried had succes with connecting the Database component to an Ms Acces database file ?
I just tried to make an simple website : Database1 + Table1 + DataSource1 + DbGrid1 connected together to display/edit a table.
To connect to an MsSql Server database is no problem.
When I tried to connect to an Ms Acces database file (mdb), I got all the time erros.
I tried :
DataBase1 DriverName = "ado" , "ado_acces", "acces", "odbc"
and
DataBase1 DataBaseName = either "D:\MYDB.mdb" , either "TEST" - the name of an ODBC connection.

For all situations I got errors.
Did anybody had succes in getting connected to an mdb file ?
As far as I read in help, it should be possible to get connected to an MsAcces database.

Thank you in advance.

[405hp]

database problems

[katran]

Thank you for your answer.
I have found the example 2 days ago and it is working.

But .... I want the DATABASE/TABLE components to connect to the database.

Do you think I can write something like :

$connstr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source =" . realpath("Projects.mdb") ."";
Table1->Open($connstr)
or Table1->Connection($connstr)
or Table1->Database($connstr)

What I want at the end, is to use the grid. But the Grid has to be connected to an DataSource, and the DataSource to an Table or Query component.
So finally I need to work with the Table component.
How to connect the table component to an Ms Acces database ?
Sorry ... I am completely new in PHP.

[405hp]

I have not used it but the doc's say it works.

ADODB Manual

The database component shows ado_access and access in the drop down for drivers.

[katran]

I know the doc. But for me did not work.
I tried several drivers (including these 2 you said).
If I will find a way, I will post the code.
Thanks for your replies.

[merovingio]

I use
Database->DriverName = "access";
Database->Host =
"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=f:\\scuole.mdb;"
Table->Table = "scuole" // table
But I only read records with DBControls.