Using MS Access DB: dependencies?

  • Thread starter Thread starter nagar
  • Start date Start date
N

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
 
My experience has been that MS Access and ADO.NET (whether Odbc or OleDb)
is very, very slow. You really ought to look at SQL Server 2005 Express.

--
Robbe Morris [Microsoft MVP - Visual C#]
AdvancedXL Server, Designer, and Data Analyzer
Convert cell ranges in Excel to rule driven web apps
without IT programmers.
Free download: http://www.equalssolved.com/default.aspx
 
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 ([email protected], 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.
 
Back
Top