Access 2000 table record limit

[James Stanich]

Is there a limit on the number of records that a table can hold?

[mattm]

I'm going to guess at yes, I am having problems with the number of fields a record can hold (see my previous post). So, I would think they have limits to records in tables also.

[alex_read]

Erm, Yes there is. I THINK, that it's either 30,000 or 32,000.

[Ryanp]

I believe the size limitation is not in number of records but rather space (1GB to be precise). I have also heard tell that there is an overall 1GB limit to the size of the whole DB.

[alex_read]

Ryan, there is both.

I think (and I will say think as I'm not at work and can't look this up exactly), but :

30,000 or 32,000 records or
2GB

I am fairly sure it's 2GB here. Well thought of though as I didn't think of this one.

[new_money]

30,000?????

I've had around 400,000 in an Access 2.0 db.

In 2.0 the limit was 1Gb for the whole db.

[James Stanich]

Do you think the objects are records?

Or possible the sum of all reports, quesries, modules, forms, etc that can be made in Access?

Access97 database size 1GB

Access2000 database size 2GB

Oracle......depends whats left on the machine after installing its files.

[jmcswain]

These numbers can all be found by typing "specifications" in any microsoft application's "answer wizard" section of the help file.

James - objects are tables, queries, forms, reports, macros, and modules.

Access 2000 Table Specs
--------------------------------
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of open tables 2048. The actual number may be less because of tables open internally by Microsoft Access.
Table size 1 gigabyte
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through the user interface;
1 gigabyte when entering data programmatically.
Size of an OLE Object field 1 gigabyte
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields) 2,000
Number of characters in a field property setting 255

Access 2000 General Specs
-----------------------------------
Attribute Maximum
Microsoft Access database (.mdb) file size 2 gigabytes. However, because your database can include linked tables in other files, its total size is limited only by available storage capacity.
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set to True) 1,000
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255

[James Stanich]

Thanks all who answered...

Originally posted by James Stanich
Thanks all who answered...

Your welcome. Have a look at MySQL as well, this board stores it's records etc in it.