is not a valid path

Question

User800852009 posted

Hi,

   I am using a microsoft access database for my website. This access database links to the other databases on the network.I am trying to host the web site using IIS and I am getting following error.

'I:\Data\DATA\vbproject\data.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 :

 <add name="MOMSConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot;C:\Inetpub\wwwroot\MyWebsite\App_Data\Records.mdb&quot;"
   providerName="System.Data.OleDb" />

Records.mdb has links to the other databases.

Please help me with this.

Thanks

is not a valid path

Answer 1

User-1853252149 posted

 Is I: a shared drive and did you configure the proper permissions for the drive for access?

Jeff

Answer 2

User-1199946673 posted

 try:

connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Records.mdb"

The DataDirectory Directive points to the App_Data folder:

http://www.mikesdotnetting.com/Article/78/AccessDataSource-SqlDataSource-and-connecting-to-Access-databases-in-ASP.NET