How Many Records can 1 Access Table Hold

[Terry]

I am needing to know how many records (lines) 1 Access
Table will hold.

 

[JohnFol]

or 1.2Gb for earlier versions . ..

 

[Simon Harvey]

I am needing to know how many records (lines) 1 Access
Table will hold.

If you need more than 2G in an access database, you really should consider
at least going to msde for better performance and more realistically SQL
Server



Simon

 

[Tony Toews]

or 1.2Gb for earlier versions . ..

1 Gb.

Tony
--
Tony Toews, Microsoft Access MVP
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

 

[Rebecca Riordan]

But then there's the Unicode issues, so....are we repeating ourselves? <g>

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

 

[Rebecca Riordan]

Hmm, that's interesting...but I suppose the Unicode 2-byte thing only
applies to _text_ data, so numeric and blob data would be uneffected,
wouldn't it?

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

 

[Larry Linson]

Hmm, that's interesting...but I suppose
the Unicode 2-byte thing only applies to
_text_ data, so numeric and blob data
would be uneffected, wouldn't it?

Yes, and also, Unicode compression is "on" by default, and most characters
in Western languages compress to only one byte -- in those cases, Unicode
just adds a bit of overhead in the data storage.

Larry Linson
Microsoft Access MVP