The Access program can have tables in excess of 50,000. I have personally seen one table with more than 250,000, but anything larger than 50,000 is not recommended by Microsoft or by our IT staff because of possible corruption problems.
From: Museum discussion list [mailto:[log in to unmask]] On Behalf Of Timothy McShane
Sent: Wednesday, September 30, 2009 11:18 AM
To: [log in to unmask]
Subject: Re: [MUSEUM-L] collections management software
>>> "Baumann, Timothy E" [log in to unmask]> 9/30/2009 8:02 AM >><mailto:[log in to unmask]:02%20AM%20%3e%3e>
Please note that this program should not be used to store more than 50,000 entries within a table.
Why is that? I was managing an Access v2.0 database back in the mid-90s that had almost 60,000 records in the primary table, with no ill-effects. Surely, modern versions of the product are at least as capable as the ones from 16 years ago?
- Tim
Disclaimer: The information transmitted is intended only for the
addressee and may contain confidential, proprietary and/or privileged
material. Any unauthorized review, distribution or other use of or
the taking of any action in reliance upon this information is
prohibited. If you received this in error, please contact the sender
and delete or destroy this message and any copies
========================================================= Important Subscriber Information:
The Museum-L FAQ file is located at http://www.finalchapter.com/museum-l-faq/ . You may obtain detailed information about the listserv commands by sending a one line e-mail message to [log in to unmask] . The body of the message should read "help" (without the quotes).
If you decide to leave Museum-L, please send a one line e-mail message to [log in to unmask] . The body of the message should read "Signoff Museum-L" (without the quotes).
=========================================================
Important Subscriber Information:
The Museum-L FAQ file is located at http://www.finalchapter.com/museum-l-faq/ . You may obtain detailed information about the listserv commands by sending a one line e-mail message to [log in to unmask] . The body of the message should read "help" (without the quotes).
If you decide to leave Museum-L, please send a one line e-mail message to [log in to unmask] . The body of the message should read "Signoff Museum-L" (without the quotes).