Site Server Web Administrator Stops Responding When You Add a Member (258300)



The information in this article applies to:

  • Microsoft Site Server 3.0

This article was previously published under Q258300

SYMPTOMS

When you attempt to add a member into an Access membership database, the Site Server Web Administrator program may stop responding if you have a large number of users in your directory.

CAUSE

An Access database is not designed to accommodate a large number of users.

WORKAROUND

To work around this issue, set up a new directory using SQL Server as the backend datastore, and then migrate the existing members from Access to SQL Server. It is possible to migrate members programmatically using ADSI or OLEDB, but it is not possible to transfer the Access-database schema to SQL Server because the tables are not identical.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Site Server version 3.0.

MORE INFORMATION

An Access database can only be used for development or for proof of concept. It is not recommended to deploy it in a production environment where performance is critical.

Modification Type:MajorLast Reviewed:4/5/2000
Keywords:kbprb KB258300