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 >>
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).
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).