Presence and future of data access



Hi,

I don't understand todays database technologies entirely:
1, I thought DAO has been deprecated, but Access 2003 still seems to use it.
2, What about Jet engine through ADO? OLE DB driver for Jet isn't included
in latest MDAC redistributables. So how do I work with Access mdb databases -
in smaller projects when SQL Server won't pay off?
3, How does .NET change this?

I'll be glad if someone explains it to me.
Thanks for response.

.



Relevant Pages

  • Re: How to search for apostrophes
    ... > Using ADO instead of DAO it works. ... > in the SQL query, ... There is also an "All about the Jet Engine" series of ...
    (microsoft.public.vb.database)
  • Re: ADO & Multithreading
    ... > Jet Engine die Daten erst etwas verzögert auf die Festplatte schreibt. ... Bei DAO gibt's entsprechende Optionen, ... > theoretisch bei ADO auch, aber sie scheinen keine Wirkung zu zeigen. ...
    (microsoft.public.de.vc)
  • DAO: SetFieldValue fail??
    ... I have a function to Add record using DAO to Access mdb file in VC.Net 2003. ... I already update the Jet Engine to 4.0SP8. ... Kevin Tang ...
    (microsoft.public.data.ado)