Using MS Access DB: dependencies?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • nagar@community.nospam

    Using MS Access DB: dependencies?

    I would like to use a MS Access database to store data for a .NET 2.0
    application. Do I need to distribute MDAC or extra runtime files with
    it?
    Thanks,
    Andrea
  • Walter Wang [MSFT]

    #2
    RE: Using MS Access DB: dependencies?

    Hi Andrea,

    Based on your requirement, I agree with Robbe that you might want to
    consider using SQLServer express version instead of Access.

    On the other hand, the MDAC component no longer contains Jet components
    (required to access Access database) since 2.6, it's now included in latest
    system service pack:

    MDAC version 2.6 and later do not contain Jet or Desktop ODBC drivers
    (http://support.microsoft.com/kb/271908)

    How to obtain the latest service pack for the Microsoft Jet 4.0 Database
    Engine (http://support.microsoft.com/kb/239114/)


    Regards,
    Walter Wang (wawang@online. microsoft.com, remove 'online.')
    Microsoft Online Community Support

    =============== =============== =============== =====
    When responding to posts, please "Reply to Group" via your newsreader so
    that others may learn and benefit from your issue.
    =============== =============== =============== =====

    This posting is provided "AS IS" with no warranties, and confers no rights.

    Comment

    • nagar@community.nospam

      #3
      Re: Using MS Access DB: dependencies?

      Thanks for the reply.
      I need a very lightwight DB. I'll check out sqlite.
      Thanks,
      Andrea

      On Mon, 18 Feb 2008 02:01:44 GMT, wawang@online.m icrosoft.com ("Walter
      Wang [MSFT]") wrote:
      >Hi Andrea,
      >
      >Based on your requirement, I agree with Robbe that you might want to
      >consider using SQLServer express version instead of Access.
      >
      >On the other hand, the MDAC component no longer contains Jet components
      >(required to access Access database) since 2.6, it's now included in latest
      >system service pack:
      >
      >MDAC version 2.6 and later do not contain Jet or Desktop ODBC drivers
      >(http://support.microsoft.com/kb/271908)
      >
      >How to obtain the latest service pack for the Microsoft Jet 4.0 Database
      >Engine (http://support.microsoft.com/kb/239114/)
      >
      >
      >Regards,
      >Walter Wang (wawang@online. microsoft.com, remove 'online.')
      >Microsoft Online Community Support
      >
      >============== =============== =============== ======
      >When responding to posts, please "Reply to Group" via your newsreader so
      >that others may learn and benefit from your issue.
      >============== =============== =============== ======
      >
      >This posting is provided "AS IS" with no warranties, and confers no rights.

      Comment

      Working...