I started developing ASP.NET web applications about three weeks ago. I was doing perfectly with sql databases and all the server controls but when I tried to access an Access database, I got this wierd error, something to the effect of:
"The database file (database file path and name) cannot be opened. Either another user is connected or you need permsission to view its data" - then there is a reference to System.Data.OleDb.OleDbException..
I have searched high and low for information about this error and all I have found is in the book "ASP.NET programming with C#" by Wrox. The book talks about this kind of thing being a common issue with Access databases and you can fix it by adding a new user and setting the WRITE permission to checked (or on). I tried this but the book is talking about iis 5.0 and I have iis 5.1 (what difference this makes I don't know) Anyway, I still get the error and any addition of the WRITE permission does not effect anything that I need it too. Help... Its driving me crazy.