Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old November 19th, 2006, 05:58 PM
Registered User
Join Date: Nov 2006
Posts: 5
Thanks: 1
Thanked 0 Times in 0 Posts
Default 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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Membership and Role Providers with Access Database kanzeon4 ASP.NET 2.0 Professional 1 April 2nd, 2008 04:09 PM
Custom Membership Provider and Login Control sonishpaul ASP.NET 2.0 Professional 2 December 14th, 2007 02:36 PM
Simple ASP.NET Membership Provider Login jumpseatnews ASP.NET 2.0 Basics 0 July 16th, 2006 10:53 AM
Chapter 4: Membership and Identity. (Access 2003) shirley65 BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 7 March 23rd, 2006 03:09 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.