Size Limit Of Access Database

  • Thread starter Thread starter Lloyd
  • Start date Start date
I got mine from one of my programming books, but I also note that Microsoft
has some of this info in their Knowledge Base.
 
Thank you:
["Lloyd"] & ["Gina"]
2 gig for database and 1 gig for table... atleast for 2000.

Lloyd
Click to expand...

I was told that an Access Database can only be about at the most
and still function properly about: 200mb ???

I guess the person that said this on another NG was wrong.
This is very, very good news. As I was afraid that I was going to
Have to build another server with "SQL" to handle the database.

Thanks a lot everyone.

Great, Great News. :-)

Wayne
 
I got mine from one of my programming books, but I also note that
Microsoft has some of this info in their Knowledge Base.
Click to expand...
Hmmm: the MVPs here assert that a table can be as big as it likes as long
as it fits in the mdb file: i.e. 2 GB minus whatever overhead Access likes
to put in for security/ forms/ indexes/ system tables etc etc etc.

And I still don't know how anyone is meant to know how big a table is
anyway.

All the best


Tim F
 
No disrespect to the MVP's here... I was only answering what I found in my
book and on MS's site. I do note that there is no way to know the size of
any one table in particular, unless of course it can be found in those
hidden object tables I never bother to look at.

Bowing head in respect... <grin>
 
Back
Top