读取 Microsoft Access 数据库 64 位 [英] Reading Microsoft Access Database 64bit

问题描述

我将我的 .NET 应用程序移动到 64 位，但我仍然需要从 C# 代码中的 Microsoft Access 数据库读取数据.我有一个建议，我可以编写一个 Web 服务，定期从 Microsoft Access 读取数据并将其转储到 SQL Server，这样我就可以从应用程序中的 SQL 表中读取数据，而不是直接访问 Microsoft Access 数据库.

I have a situation where I'm moving my .NET application to 64bit and I still need to read data from an Microsoft Access database from within C# code. I've had a suggestion where I could write a web service that reads the data periodically from the Microsoft Access and dumps it into SQL Server, so I could then read from SQL table in my application rather than accessing the Microsoft Access database directly.

这存在一些问题，例如从 Web 服务或 WCF 服务读取特定 PC 上的 Microsoft Access 数据库.但我想拥有相关权限的帐户可以解决这个问题.

This has issues like reading from the Microsoft Access database on a specific PC from the web service or WCF service. But I guess an account with relevant permissions would resolve this.

有没有人遇到过这样的情况?如果是这样，你是如何解决这个问题的?

Has anyone else had a situation like this? If so, how have you worked around it?

提前感谢您的指导.

推荐答案

您能否使用 ACE OleDb 提供程序将您的 .Net 应用程序连接到 Access?

Can you use the ACE OleDb provider to connect your .Net application to Access?

可免费下载，提供 32 位和 64 位版本.Microsoft Access 数据库引擎 2010 可再发行版

It's a free download, available in both 32 and 64 bit versions. Microsoft Access Database Engine 2010 Redistributable

这篇关于读取 Microsoft Access 数据库 64 位的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！