[AccessD] Record Maximum

If you want a testimonial tell your customer that all our financial
reporting and profit planning is done via an Access database into which data
is downloaded from an AS400 and which is used to produce dozens of Excel
reports to the board and Sr management,ie if this sytem ever went down I
would be in deep doo. We are $600 million in sales with 160 locations. The
system has run reliably for 5 years, currently the back end is over 500mb.
If properly build they should not have problems.
Jim Hale

-----Original Message-----
From: Gowey Mike W [mailto:Mike.W.Gowey at doc.state.or.us]
Sent: Tuesday, October 31, 2006 8:21 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Record Maximum



Thanks guys for your input.  I was just looking for some ways to explain
to the customer that the rumor that they heard about Access databases
crashing when the size of the database reached over 100mb.  I already
explained that this was a vicious rumor and explained to them how it
works, but they were not totally convinced so I was looking for more
amminition to though at them to eleviate their concerns.

Thanks again 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
Hindman
Sent: Monday, October 30, 2006 5:36 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Record Maximum

...as JC pointed out, the "number" of records is rarely the driving
factor ...I'd add to JC's comments that the record length plays into the
issue as well ...if each record is 2k its a major factor in your
considerations.

...and while record count IS a factor in archiving, its not THE major
factor ...I baseline archive a record whenever it meets certain client
specific milestones and only IF the client concurs on a record by record
basis ...a dead record is a dead record whether there are 2K or 2M of
them

William Hindman

----- Original Message -----
From: "Gowey Mike W" <Mike.W.Gowey at doc.state.or.us>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, October 30, 2006 4:38 PM
Subject: [AccessD] Record Maximum


>
>
> Hi Everyone,
>
> Just a quick question.  What is the maximum or the most records that
> anyone has seen in a table before the database started to degrade in
> permormance.
>
> What would you consider the maximum record count before archiving?
>
>
> TIA for your thoughts,
>
> Mike Gowey  MCP, MCDST, MCSA, A+, LME, NET+
> Team Leader - SouthEast Region
> Information Systems Unit
> -- 
> 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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.