ASP.NET and Access Databases

Question

Hi,

I have an ASP.NET web application that accesses an Access Database. The Access Database is only for testing purposes. I have hard coded the connection string which is correct, yet the application throws an error saying:

C:\MyDb\Db.mdb is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

My Connection String is:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDb\Db.mdb;

This is the correct path, why can't the developement server see the database? Do I have to configure it?

Please Help

Answer 1

See 'Not a valid path' Error when Using Access Data Source, I think it may help.

Answer 2

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDb\Db.mdb;Persist Security Info=True

Answer 3

Are you using IIS? If so, does the IIS server have access to this file directory?