Working with Access database from a 64-bit ASP.NET application
I have an application uploading Access MDB (its file format) that I need to pull data from. I HAVE NO CONTROL OVER THIS FILE TYPE OR FORMAT. My problem is that my web application is a 64-bit application and CANNOT BE CHANGED. JET doesn't work with 64-bit systems. Every answer I've found is to set my configuration to x86 (32-bit) and I cannot do this with my web application. I've also tried ACE with the same result.
I need a 64-bit way to read data from an Access data base file, or spin off a 32-bit thread to get to my data, or something.
I am so frustrated. Access is a misnomer. They should call it MS MyDataIsTrapped开发者_运维问答InHell.
Just create a separate 32 bit assembly for your data access, which you can then reference in your web application
精彩评论