If you didn't understand my first answer, you don't understand the
relational data model.
As for your second example, depending on various settings and the
barometric pressure, and assuming the table is not indexed, conceivably
it could contain more than 30 million records. With an index, I'd guess
- and it is a guess - maybe 10 to 20 million.
But there's no formula to convert this into what would happen with
different structures.
more than 30 millionOn Tue, 8 Feb 2005 13:53:02 -0800, "mac_see"
<(E-Mail Removed)> wrote:
>I did not understand the answer. Actually, I want an answer for the second
>scenario:
>
>If I have a database with one table and only one field of type "Text" with
>every record having a string of 30 characters long, How many records can I
>add so
>that the database size is under 2 Gigs?
>
>
>"John Nurick" wrote:
>
>> On Tue, 8 Feb 2005 10:07:07 -0800, "mac_see"
>> <(E-Mail Removed)> wrote:
>>
>> >I know 2 Gigs is the limit for Access.
>> >
>> >If I have a database with one table and only one field of type "Byte" (0-255
>> >numbers), How many records can I add so that the database size is under 2
>> >Gigs?
>>
>> A pointless exercise: however many records you add to this table, you
>> can store the same information in a smaller table containing not more
>> than 256 records with two fields, one Byte and one Long: just over 1 kb
>> of data.
>>
>>
>> --
>> John Nurick [Microsoft Access MVP]
>>
>> Please respond in the newgroup and not by email.
>>
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
|
Similar Threads
