 |
28-Jul-2006, 08:30 AM
|  | Guest | | | | | | | | | | Re: General Question about records in a table
"tanhus" wrote in message
news:275C5E62-87FF-40AD-9624-D4CC9291ECE9@microsoft.com...
>I was just wondering, if access has a maximum number of records it can hold
> in a given table.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12557
The maximum is only on the file size. 1GB for Access 97 and older. 2GB for all
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12557
newer versions. Assuming Jet (MDB) tables of course.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
|
28-Jul-2006, 08:30 AM
| | Guest | | | | | | | | | | Re: General Question about records in a table
tanhus wrote:
>I was just wondering, if access has a maximum number of records it can hold
>in a given table.
FWIW a friend a while back had 100,000,000 records in a table. Daily
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12557
closing stock prices for a few years. Fully normalized.
Tony
--
Tony Toews, Microsoft Access MVP
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12557
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
| 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Active Discussions | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | » Books You Should Read... | | | |
