ADODB

[fi.or.jp.de]

Hi All,

I am using reference "Microsoft ActiveX Data Objects 2.x Library" for
connecting access database.

dim DB as adodb.connection
dim RS as adodb.recordset

is there any way without using the above reference and also DAO
objects.
Can I connect with access database ?

 

[GS]

fi.or.jp.de submitted this idea :

Hi All,

I am using reference "Microsoft ActiveX Data Objects 2.x Library" for
connecting access database.

dim DB as adodb.connection
dim RS as adodb.recordset

is there any way without using the above reference and also DAO
objects.
Can I connect with access database ?

No! You have to use a data provider to connect to a data base with ADO.
Also, to connect to an access database (MDB) you need to use different
providers depending on which version of Excel you're using. V11 and
earlier use JET 4.0; v12 and later use ACE 12.0.

 

[Harald Staff]

You can reference at runtime, it's called Late binding. Example
http://www.yhbnews.com/technology/a...avoid-missing-reference-compatibility-issues/
and others at
http://www.google.com/search?hl=en&...561&q=ado+late+binding&aq=f&aqi=g-v1&aql=&oq=

HTH. Best wishes Harald

 

[AB]

for my 0.02 of worth - as per Harald - you need to google for 'late
binding' - that's the best option there is to avoid pc setup up
differences due to different .dll versions.
Also, the connection provided you use DOES NOT depend on which Excel
version you use but depends on which Access database version you use -
eitehr .mdb or .accdb - then providers are different.
In current environment, I personally, find that using the .mdb still
provides all the features i need from simple databases and i do not
need to migrate to .accdb as yet.

 

[GS]

AB formulated on Friday :

Also, the connection provided you use DOES NOT depend on which Excel
version you use but depends on which Access database version you use -
eitehr .mdb or .accdb - then providers are different.

Thanks for making this correction! My bad for not specifying the db
source...