Re: Direct Access to MS ACCESS

From: Herbert Sitz (hsitz_at_nwlink.com)
Date: 02/08/04 

Date: Sun, 8 Feb 2004 08:38:10 -0800

"Raymond J. Schappe" <rschappe@isthmus-tsNS.com> wrote in message
news:40250e56$1@newsgroups.borland.com...
> > Can someone recomend component(s) for direct connection to MS Access ?
>
> How about mODBC ?
>
> http://go.to/modbc
>
> I believe I used this a while back and it worked well.
>
> Note, you will need M$'s MDAC installed, but I have yet to find a client
> workstation that does not have MDAC already installed.
>
> -- Raymond
> Raymond J. Schappe
> Isthmus Technology Solutions, LLC
> ______________________________________
>

I'm sure this works, but I think using DAO or ADO rather than ODBC to
connect to Access databases is a better move. ODBC is more general
purpose/generic than ADO. ADO, in turn, is more general purpose than DAO
(which I believe is specific to Access/Jet), at least as far as Access
databases go. You generally lose features and or performance when your
access method becomes more general purpose.

Actually, I think ADO has a few more features than DAO even when you connect
to Access databases with it, but DAO is specific to Access and I think
things are a bit more efficient when DAO is used with Access/Jet. Not a big
deal. But if I had a choice I would use ADO or DAO unless I planned on
porting the app to a database that didn't support ADO in the future, in
which case ODBC might be a smart choice.

-- Herb

Relevant Pages

  • Re: Access Compact/Repair in ADO.Net?
    ... I needed to do this for some Access databases that were password ... protected, with ADO, and that's how I ultimately did it. ... which still rely on some Access 97 databases, invoked the DAO 3.5 Object ... functionality is provided in any of .Net Framwork's System.Data classes? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO/DAO
    ... ADO - Microsoft generalized data access technology for most data sources ... DAO is generally faster when using access databases. ... > Can anyone give me a information on the differences between ADO and DAO? ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to enforce subtypes/supertypes in Access 2000?
    ... DAO is the native object model for Jet databases and, as such, is the ... ever need ADO. ... Private Sub SetContactType() ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Access 2007 and VB
    ... "unrecognized database format" ... There is a bit of confusion with ADO access to the new MSAccess ACCDB ... You could reference "DAO". ...
    (microsoft.public.vb.general.discussion)
  • Re: Access 2007 and VB
    ... and link to the download as a non expert some ... There is a bit of confusion with ADO access to the new MSAccess ACCDB ... You could reference "DAO". ...
    (microsoft.public.vb.general.discussion)
Loading