Re: Upsizing to SQL Server

Tech-Archive recommends: Speed Up your PC by fixing your registry



00
"Robert1105" <Robert1105@xxxxxxxxxxxxxxxxxxxxxxxxx> дÈëÏûÏ¢ÐÂÎÅ
:9DD1C57D-058C-4EB4-B318-D9A2535963BF@xxxxxxxxxxxxxxxx
> We are migrating from Jet to MSDE with Access 2000. Are the user
limitation
> the same in both? Should we be able to support the same number of
concurrent
> sessions with MSDE as we did with Jet. It seems that this should be the
> case. I was just wonder what the real world experience is with this?
>
> When you say MSDE is a "clipped" version of SQL, what is done to clip the
> MSDE?
>
> Regards,
>
> "Pat Hartman" wrote:
>
> > If you are using SQL server you shouldn't run into limitations as long
as
> > you have SQL server licenses for everyone. The limitation was probably
> > referring to MSDE. That is a crippled version of SQL server that ships
with
> > A2K and newer.
> >
> > "Weste" <Weste@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:3782DDBE-11DE-4523-B06E-C6719916CFE8@xxxxxxxxxxxxxxxx
> > > 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.
> > >
> >
> >
> >


.



Relevant Pages

  • RE: Is MSDE supported by Microsoft SQL Server 2000 driver for JDBC
    ... MSDE 2000 is supported. ... Microsoft Developer Support - Web Data ... Is MSDE supported by Microsoft SQL Server 2000 driver for JDBC ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Upsizing to SQL Server
    ... We are migrating from Jet to MSDE with Access 2000. ... Should we be able to support the same number of concurrent ... > you have SQL server licenses for everyone. ... The limitation was probably ...
    (microsoft.public.access.conversion)
  • Re: Why PHP?
    ... of MSDE and SQL Server Personal Edition. ... Express or MSDE. ... It's strictly a limitation on how you can use the OS. ...
    (borland.public.delphi.non-technical)
  • Re: Migrating a database from SQL Server to MSDE
    ... We're deploying an MSDE database on Windows XP Embedded. ... Is the limitation ... 2GB of data or 2GB of system RAM? ... > Instances of SQL Server Standard Edition and MSDE on the same machine is ...
    (microsoft.public.sqlserver.msde)
  • Re: ASP.NET with MySQL backend?
    ... Actually, they don't support MSDE. ... MSDE is probably good for a desktop app. ... > If I have a contengency plan of moving from SQL Server to MSDE or MySQL, ... >> good control panel, to setup databases, emails, ftp etc.. ...
    (microsoft.public.dotnet.framework.aspnet)