ADO + COM

[Chris]

Can anybody help?
I use the following syntax in my COM object to connect MS Access 2000 database

'conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\MyDB.mdb"


Yet, I always encounter the following error
Error: 430 No such interface supported

But, When I try to connect a SQL database, everything is file. My question is, it is MTS does not support Acess database transaction?

[Chris]

I juz resolve this by create a System DSN. Why, for MS Access database we need to use the System DSN and can not direct use the Provider properties like


conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\MyDB.mdb"