IBlog<Johan>

This and that in a developer's life in general

News

Follow johandanforth on Twitter

Random Links

Walkthroughs and Tutorials

[.NET 2.0] Membership and Personalization Provider for Access Database

Not sure why vs2005 didn't ship with providers for Access databases, but Access is quite useful if you want to develop small and simple websites and do not have access to SQL Server or similar. I run a small website hosted by an ISP and even though they support ASP.NET 2.0, I don't have access to SQL Server.

A sample Access provider is available for download on the MSDN ASP.NET Developer Center section with Provider Toolkit information. I've tried it, and it seems to work good enough for my needs. I'm having some troubles writing to the database under IIS on Windows 2000, even if I set all the security and permission stuff as it should be. Well, as long as it works under Cassini and on my website I don't care :)

EDIT: Stupid me, even though I had set access rights and permissions on all folders down to APP_DATA, the MDB-files still had the old permissions set on them. I explicitly gave the ASPNET user write access to the file and now it works like a charm :)

Posted: Apr 24 2006, 10:42 AM by jdanforth | with 2 comment(s)
Filed under:

Comments

scottgu said:

Hi Johan,

I also have a list of other providers for membership (as well as a lot of other security information) here: http://weblogs.asp.net/scottgu/archive/2006/02/24/438953.aspx

Hope this helps,

Scott
# April 24, 2006 6:17 AM

Johan said:

Excellent resource, thanks Scott! I'm surprised I didn't find that during my membership provider Googling :)

Johan
# April 24, 2006 7:58 AM