Max Records Allowed In An Access 2002 Table

  • Hi all,


    What's the magic number? Or is it 'Infinite'? By way of comparison, I understand an Excel worksheet maxes out at 65536 rows...


    Thanks in advance to anyone who can advise.


    Cheers!

  • Re: Max Records Allowed In An Access 2002 Table


    There's a limit of 2GB on the size of an mdb file in Access 2000 (1 GB in Access 97) - not sure if this got upped again for Access XP.


    Subject to this, there's no fixed limit on the number of records or the size of a table. If necessary you can store different tables in different mdbs; or you can use SQL Server Express (which i think has a 4GB limit) as the back end and store vastly more data than this.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!