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

问题描述

我有一个情况我感动我的.NET应用程序以64位和我还需要从C＃code读取从Microsoft Access数据库中的数据。我有一个建议，我可以写从Microsoft Access中定期读取数据，并转储成SQL Server中的Web服务，这样的话我可以从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.

这有一个像从Microsoft Access数据库从Web服务或WCF服务的特定PC机上阅读的问题。但我想有相关权限的帐户将解决这个问题。

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应用程序来访问？

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屋！