How Many Records can 1 Access Table Hold

  • Thread starter Thread starter Terry
  • Start date Start date
Terry said:
I am needing to know how many records (lines) 1 Access
Table will hold.
Click to expand...


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
 
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...
 
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...
 
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?
Click to expand...

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
 
Back
Top