[AccessD] Access and SQL Server

Jim Lawrence accessd at shaw.ca
Tue Mar 1 10:49:32 CST 2011


If John makes his new applications work stability, I will truly be
delighted. 

If they do not, I promise to try to resist the temtation to say "I told you
so". ;-)

Jim



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Monday, February 28, 2011 1:14 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access and SQL Server

A few small tables and limited number of users it's fine.  

Try over 50 concurrent operators  inserting/updating  records in  tables
with up to 7 million 
rows with multiple large lookup tables on that data.  At the same time have
a number of  
others users pulling summaries of that data.   Not fine.  :-)

-- 
Stuart

On 28 Feb 2011 at 12:01, jwcolby wrote:

> Cringe away, it seems to work just fine.  Until I see evidence to the
> contrary...
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> On 2/28/2011 10:56 AM, Jim Lawrence wrote:
> > Years ago I dropped a table in error, on a live MS SQL DB...had
> > about 50 users on at the time. Added the table and re-populated in
> > about 5 minutes and only 1 person complained about the BE being
> > slower and having to do a refresh. Real SQL DBs are very
> > rugged...everything is just queued, cached and applied through
> > background processes.
> >
> > The one thing is that a Real SQL DB is not just another MDB...there
> > is little or no resemblance other than the both hold data. (Not
> > wanting to get into a heated discussion, I must admit I cringe every
> > time I hear of someone attempting a bound MS SQL DB.)
> >
> > Jim
> >
> >
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
> > McLachlan Sent: Sunday, February 27, 2011 2:41 PM To: Access
> > Developers discussion and problem solving Subject: Re: [AccessD]
> > Access and SQL Server
> >
> > Both?
> >
> > When did you ever have to kick users out of Access or any other
> > multi-user DBMS to make data changes?
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list