Reputation: 99
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
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