Access 2000 Table

G

Gary

I created a table roughly a year and a half ago. The table has been modified
numerous times and now holds over 10,000 records. I am concerned that I may
have to start a new table at some point if Access will no longer accept new
records. Is there a limit as to how much information or how many records can
be held?
 
D

David Conger [MSFT]

Unless we had a restriction on number of rows in Access 2000, based on
specifications for newer version of Access (2003), you aren't restricted by
rows but by file size.

http://office.microsoft.com/en-us/access/HP051868081033.aspx

As long as your file hasn't reached the 2GB max, you can keep adding rows.

--
David Conger
Software Development Engineer in Test
Microsoft Office Access

** This posting is provided "AS IS" with no warranties, and confers no
rights. **
 
J

John Vinson

Gary said:
I created a table roughly a year and a half ago. The table has been modified
numerous times and now holds over 10,000 records. I am concerned that I may
have to start a new table at some point if Access will no longer accept new
records. Is there a limit as to how much information or how many records can
be held?
Click to expand...

You're limited to two BILLION bytes, total size of the database. Use
Tools... Database Utilities... Compact and Repair Database occasionally to
clear waste space.

I've used databases with over a million rows, and I know of Access
applications with 20,000,000 rows in the largest table. You're nowhere near
running out of room.
 
Top