How to distribute ADO Library

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Marty (mjalfonsi_at_newsgroup.nospam)
Date: 01/21/05 

Date: Thu, 20 Jan 2005 19:32:36 -0500

We deploy an application that contains an Microsoft Access .mdb file.

Within the .mdb file are some forms that use VB and ADO. This code has in
it's reference list ADO version 2.5.

The recipients of our application have varying models and versions of Window
(Win2000, Win XP Prof, Win XP Home etc) but nothing below Win 2000.

Some of our recipients have Full Version Access of varying levels (2000,
2002 etc) but no Access 97.

Some receipients do not have ADO version 2.5, we are not sure if they tend
to be higher or lower.

Is there a version of ADO that we can use that will give us the broadest
acceptance?

Is there a way of including a particular library with or distribution?

Thanks

Relevant Pages

  • Re: How to enforce subtypes/supertypes in Access 2000?
    ... So I focussed on the dirty event. ... If I code everything using DAO now, will I need to re-code everything ... into ADO later, or does VB.Net not care which one you reference? ... Will they be packaged with my .mdb file if I ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Unable to open Acces files on a server
    ... Access file through ADO, which does not need either to start ACCESS ... manipulate data n that *MDB file (Assume you do it in a stand-alone VB app ... > Dim MyConn As ADODB.Connection ... > Set MyConn = New ADODB.Connection ...
    (microsoft.public.vb.general.discussion)
  • Re: Performance problem
    ... I was doing an unnecessary SQLAllocHandle and SQLFree inside a tight loop which when removed got things going again. ... It's certainly might, the one big advantage of using a mdb file is that jet 4.0 ships with windows, and windows vista right out of the box. ... The beauty of this approach would be that you would be able to run your code on Windows XP, or vista without installing additional software libraries (you'll likely have to include a ado reference in the project that you create, but other than that you would not be beholden to using MS access for your application. ...
    (microsoft.public.access.gettingstarted)
  • Re: Any REAL reason to use ADO vs. DAO?
    ... Not only should the tests be limited to a .mdb file, ... specify the Connection String (provider, file location, etc) as well as ... Cursor Types, Locations, DAO and ADO versions. ...
    (microsoft.public.vb.general.discussion)
  • Re: CONNECT MDB FILE FROM ADP FILE
    ... Just use ADO ... anyone using DAO is too rusty ... From a adp project connnected to a MSDE database, i have local setting in a ... local mdb file. ...
    (microsoft.public.access.adp.sqlserver)