Size Limit Of Access Database

[Lloyd]

2 gig for database and 1 gig for table... atleast for 2000.

Lloyd

 

[Gina]

Lloyd is right for 2k, however XP is 2 gig for table.... Thanks Lloyd forgot
about that!

 

[Gina]

I got mine from one of my programming books, but I also note that Microsoft
has some of this info in their Knowledge Base.

 

[Wayne & Carr]

Thank you:
["Lloyd"] & ["Gina"]

2 gig for database and 1 gig for table... atleast for 2000.

Lloyd

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

 

[Tim Ferguson]

I got mine from one of my programming books, but I also note that
Microsoft has some of this info in their Knowledge Base.

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

 

[Gina]

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>