CODEWITHSUNDEEP
c#ms-access64-bit
Andrew Greatorex
Andrew Greatorex

Reputation: 117

Reading Microsoft Access Database 64bit

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.

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?

Thanks in advance for any guidance.

Upvotes: 4

Views: 1970

Answers (3)

linquize
linquize

Reputation: 20406

Note that if you also need to read xlsx in 32-bit application in 64-bit windows, Install MADE 2007 instead of MADE 2010(x86), because same version of MADE 2010(x86 + x64) cannot coexist.

Upvotes: 0

HansUp
HansUp

Reputation: 97131

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

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

Upvotes: 1

Olivier Jacot-Descombes
Olivier Jacot-Descombes

Reputation: 112712

An option might be to link the Access DB to the SQL Server. See Linking Servers on MSDN.

Upvotes: 1

Related Questions