How to connect Database component to Ms Acces (mdb) database
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.
|