Devart Forums

I did not find all the information in the Documentation for my usage of the MS Access provider:

MS Access connection provider in DevArt Universal:
Is the MS Access provider a driver provided by Devart or is it using a driver installed by the operating system or MS Office (or other), i.e. for deployment : do you have to installing any additional software

the help states that it is using OleDb, but which syntax of the connect string is supported
(especially read only mode (Mode=Read; , Mode = Share Deny Write,...??)
(OleDb supports Jet and ACE, so is Devart use one of these or is this a third way)

pvalta wrote:Is the MS Access provider a driver provided by Devart or is it using a driver installed by the operating system or MS Office (or other), i.e. for deployment : do you have to installing any additional software

You should install Microsoft OLE DB provider for MS Access (System.Data.OleDb) to use it via dotConnect Universal.

Refer to https://www.devart.com/dotconnect/unive ... iders.html.

pvalta wrote:OleDb supports Jet and ACE, so is Devart use one of these or is this a third way

dotConnect Universal supports both Jet and ACE.

1)With which versions of Microsoft OLE DB provider for MS Access (System.Data.OleDb) does DevArt Universial work together?

2) is the connectstring syntax the one of Microsoft OLE DB provider exempted the provider tag (which is "MS Access" for DevArt Universal)?

pvalta wrote: ↑Thu 18 Jun 2020 09:41 1)With which versions of Microsoft OLE DB provider for MS Access (System.Data.OleDb) does DevArt Universial work together?

Microsoft.ACE.OLEDB.15.0
Microsoft.ACE.OLEDB.14.0
Microsoft.ACE.OLEDB.12.0
Microsoft.Jet.OLEDB.4.0

pvalta wrote: ↑Thu 18 Jun 2020 09:412) is the connectstring syntax the one of Microsoft OLE DB provider exempted the provider tag (which is "MS Access" for DevArt Universal)?

Yes, the connection string should be "provider=MS Access; [...]".