Using MS Access DB: dependencies?

[nagar]

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]]

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 (wa****@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.

[nagar]

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, wa****@online.microsoft.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 (wa****@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.