Record capacity Northwind

[Jim]

Does anyone know now many records the Northwind database can hold in
the 2 gig limit. Assuming that every field is used.

 

[Gina Whipp]

Jim,

Well now, that is a tricky question... There are many factors to tkae into
account. How big is the table? How many fields are in the tables? What
are the field data types? Do you run Compact & Repair weekly? What is the
rate of data entry? Are you running a lot of action queries? Any
Maek-Table queries?

I've got tables with well over 300,000 records in it and it will be years
before that thing ever reaches 2 gig. Why don't we start with what are you
doing?

On another note, let's not post your real eMaill Address for the Spammers to
get a hold of....

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Arvin Meyer [MVP]]

Does anyone know now many records the Northwind database can hold in
the 2 gig limit. Assuming that every field is used.

That's hard to say. I have 1 database with over 6 million records in it and
it is just over 1.1 GB. I have another that gets about 100,000 records every
day, but they are only 32 bytes each. Data that's over 5 years old is
archived, so the data will never be over 1/2 a GB.

Northwind is not a very efficient database design, but even it will hold
more than a million records if the images are stored out of the database.

 

[John W. Vinson]

Does anyone know now many records the Northwind database can hold in
the 2 gig limit. Assuming that every field is used.

How many boxes will fit in a 24 foot moving van?

There are small records and big records; Access trims trailing blanks in text
fields and memos, and NULL values take up no space at all, so there is no
defined size to a record, even if the field definitions all have a specific
(maximum) size.