MS Access Limitations

[Hajir Firooz]

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.

[Veign]

Re: MS Access Limitations

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" <hajir.firooz@s ympatico.ca> wrote in message
news:e2egc.3355 0$2Z6.1393978@n ews20.bellgloba l.com...[color=blue]
> 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.
>
>[/color]

[Hajir Firooz]

Re: MS Access Limitations

Thanks Chris!
I am wondering if number of records go up to 300,000 what would happen in
terms of performance. I should give it a try!

"Veign" <me@home.com> wrote in message
news:nIlgc.1347 0$zj3.4369@news read3.news.atl. earthlink.net.. .[color=blue]
> 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[/color]
dont[color=blue]
> hit any of the above limitations, then you're OK...
>
>
> --
> Chris Hanscom
> MVP (Visual Basic)
> http://www.veign.com
>
> "Hajir Firooz" <hajir.firooz@s ympatico.ca> wrote in message
> news:e2egc.3355 0$2Z6.1393978@n ews20.bellgloba l.com...[color=green]
> > Hi, I am wondering what are the limitations of MS Access 2000 database[/color][/color]
in[color=blue][color=green]
> > terms of number of records per table. Any help will be appreciated.
> >
> >[/color]
>
>[/color]

[(Pete Cresswell)]

Re: MS Access Limitations

RE/[color=blue]
>I am wondering if number of records go up to 300,000 what would happen in
>terms of performance. I should give it a try![/color]

I would. Just make up a few querids to clone records as needed.

Ultimately it will depend on what is being done with those 300k recs and how
they're indexed.

I've got one table with about that number in the form of yield history records
for securities. No problems here - but all we do is add to the table once or
twice a day and select values for reporting.
--
PeteCresswell