Using Access Databases for Login and Membership
I am sure that this is a simple (but annoying problem)
I want to be able to use an Access (2003/2000) database to control membership, login as well as the underlying site data.
I appreciate that using this database rather than a SQL Server Express or SQL server database is less robust. However the volume of data and traffic that I anticipate for this is low AND as a result the additional cost of hosting a SQLServer database cannot be justified.
I cannot set up a new website to use an Access Database to hold the site management data.
The The provider tab on the ASP.NET configuration tool says
Use this page to configure how Web site management data such as membership is stored. You can use a single provider for all the management data for your site or you can specify a different provider for each feature.
Your application is currently configured to use the provider: AspNetSqlProvider
and does not give any other choice to change
The Security Tab of the ASP.NET configuration tool for the Worx United web application says
You can use the Web Site Administration Tool to manage all the security settings for your application. You can set up users and passwords (authentication), create roles (groups of users), and create permissions (rules for controlling access to parts of your application).
By default, user information is stored in a Microsoft SQL Server Express database in the Data folder of your Web site. If you want to store user information in a different database, use the Provider tab to select a different provider.
..again I don't have (or appear to have a way to change this)
Help appreciated
Rodger
|