user3173098
user3173098

Reputation: 99

ASP.NET "Cannot write to DB File" when logging in

please help me fix this.

I am setting up a ASP.NET website using a .mdb (Access) database file. I don't want to use SQL Server because I have to pay more for the hosting.

I followed this guide to get the .mdb file working in Visual Studio: http://imar.spaanjaars.com/404/using-the-microsoft-access-providers-to-replace-the-built-in-sql-server-providers It all works fine when I run it on my local machine from VS 2008.

I have uploaded my website to my new web hosting and when I try to log in (using the ASP.NET login control) I am getting the message "Cannot write to DB File". It is not a proper error, but just a single line of text.

I have spoken to the web hosting company and they claim that all of the permissions are set up correctly.

I have been fiddling with web.config and so far no success.

Any ideas? Cheers.

Upvotes: 1

Views: 356

Answers (1)

Mike Brind
Mike Brind

Reputation: 30075

Did the Web Hosting company tell you what permissions have been set? You need Modify permissions on the folder that contains the Access database. I say "you", I mean the user account that your application runs under - most likely the App Pool that your site runs in.

Upvotes: 1

Related Questions