[AccessD] Record Maximum

Hi Mike:

The size limit is aroud 2 GB of total MDB database size. The record count
depends on the data type and number of fields. For example a MDB could reach
the limits if there are a 1000 records with pictures embedded.

HTH
Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gowey Mike W
Sent: Monday, October 30, 2006 1:38 PM
To: Access Developers discussion and problem solving
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