-
Can anybody help?
I use the following syntax in my COM object to connect MS Access 2000 database
Code:
'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?
-
System DSN
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
Code:
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\MyDB.mdb"