connect to MS Access accdb file on Windows Server 2008

Question

In my ASP.NET application I have ftpdata folder, there is an MS Access 2010 file e.g. somename.accdb.

On my local computer (Win XP), there is no problem to connect with OleDb to this file and read write datas into and from tables.

But on server (Windows Server 2008), I cannot connect to the same file like on localhost.
Can you help me, please, where problem could be?

Answer 1

Finally, I found solution of problem.

There was not installed 2010 Data Connectivity Components on the server.

Answer 2

The windows user that your application pool is running in does probably not have read access to the directory/file

Answer 3

You need either direct access through the file system or SMB networking access (via a share defined on the server). If the FTP folder has an SMB share name, use that to get to it, but it's likely not shared (since it's purpose is for FTP access, not SMB access).

Answer 4

Installing the 2010 Data Connectivity Drivers does not seem to work, what worked for me was to set the corresponding website application pool in IIS to enable 32-Bit applications.

Official Microsoft Reference: