Upsizing to SQL Server

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Weste" <Weste@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 21 Apr 2005 14:56:01 -0700

We are upsizing our current Access 97 application to SQL Server. We are
doing this in a phased approach. First we are going to upsize the tables.
We are then going to link to the SQL tables from the current Access FE. I
read that we will have limitations in terms of the number of users the
application will be able to support using this configuration from the book
Microsoft Access Developer's Guide to SQL Server by Mary Chipman and Andy
Brown. I understand that this configuration will consume more resources on
the network and server. Is this causing the limit on the number of users?
About how many concurrent users should we be able to support using this
configuration? Thanks for your help.

.

Follow-Ups:
- Re: Upsizing to SQL Server
  - From: Pat Hartman

Prev by Date: Re: Install both Access 2000 and 2003 on the same machine.
Next by Date: Re: a97 to a03 and DAO to ADO
Previous by thread: Install both Access 2000 and 2003 on the same machine.
Next by thread: Re: Upsizing to SQL Server
Index(es):
- Date
- Thread

Relevant Pages

RE: Configuration parameter in SQL database
... Welcome to Microsoft Newsgroup Support Service! ... how to store&return the configuration ... SQL Server + SQL Dependency Cache ...
(microsoft.public.dotnet.general)
RE: VB 2005 and Content Security Question
... must the sensitive data be stored in SQL Server database ... if you have some sensitive configuration setting that need to ... Microsoft MSDN Online Support Lead ... where an initial response from the community or a Microsoft Support ...
(microsoft.public.dotnet.languages.vb)
RE: VB 2005 and Content Security Question
... must the sensitive data be stored in SQL Server database ... if you have some sensitive configuration setting that need to ... Microsoft MSDN Online Support Lead ... where an initial response from the community or a Microsoft Support ...
(microsoft.public.dotnet.languages.vb)
Re: Failed to register SharePoint Services 2007
... with SQL Server 2K and use that instead of SQL Server 2005. ... When I ran the configuration databse for the first time I had a failure ... System.ArgumentException: Exception of type ... So I used the ntrights to get that privilege on my sharepoint user. ...
(microsoft.public.sharepoint.portalserver)
Re: Failed to register SharePoint Services 2007
... with SQL Server 2K and use that instead of SQL Server 2005. ... When I ran the configuration databse for the first time I had a failure ... System.ArgumentException: Exception of type ... So I used the ntrights to get that privilege on my sharepoint user. ...
(microsoft.public.sharepoint.portalserver)