This is what I found:
MS Access 97:
Max mdb file size: 1GB
Max objects in database: 32768
Max modules in database: 1024
Max object name length: 64
Max password length: 14
Max user/group name length: 20
Max users connected to database: 255
Max record length (without Memos and BLOBs): 2048
Max fields in table: 255
Max nested transactions: 7
MS Access 2000:
Max mdb file size: 2GB
Max table size: 1GB
Max objects in database: 32768
Max modules in database: 1000
Max object name length: 64
Max password length: 14
Max user/group name length: 20
Max users connected to database: 255
Max record length (without Memos and BLOBs): 2048
Max fields in table: 255
These are the only limitations of Access. So if your number of records dont
hit any of the above limitations, then you're OK...
--
Chris Hanscom
MVP (Visual Basic)
http://www.veign.com
"Hajir Firooz" <ha**********@sympatico.ca> wrote in message
news:e2*********************@news20.bellglobal.com ...
Hi, I am wondering what are the limitations of MS Access 2000 database in
terms of number of records per table. Any help will be appreciated.