Accessing ADO

[galliena]

Hello guys,

I am learning VBA by myself and I saw some codes that have the expression provider in it, like this one

Connection.Provider = "Microsoft.ACE.OLEDB.12.0"

I can not understand what is the function of the Provider in this case and where I can find the code in the right("Microsoft.ACE.OLEDB.12.0"). I would be more them glad if someone could help me.



Ps:Connection is an ADODB.Connection object.

 

[jamot1]

Hello galliena,

Using ADO, there are various providers you can use to connect to an external data source. The provider you would use would largely depend on the type of database you're trying to connect to.

For the provider string mentioned, the code is trying to connect to an Access file.

Thanks,
Thomas

 

[Fazza]

Some further information is at ConnectionStrings.com - Forgot that connection string? Get it here!

including the articles such as Connection Strings Explained - ConnectionStrings.com