What is maximum #records in a Table -Access2000

[shineybrick]

I know that Access2000 is supposed to hold up to 2gigs. But is there an actual numerical limit to the number of records you put in a table?
Thanking you in advance.

 

[JoeMiller]

No, only the size limit.

Joe Miller
joe.miller@flotech.net

 

[mrgulic]

Really? No limit.
I was told by a college instructor that teaches Access 2000 that it had a record limitation of 1 billion.
Is this wrong?
Wouldnt supprise me, he was kind of an idiot.

 

[CosmoKramer]

Check Access help for "Microsoft Access specifications"

 

[mrgulic]

i still did not see an actual record limit.
im sure with a few hundred million records that the db size would breach 2gb.

 

[CosmoKramer]

No, Joe was right, there isn't a record limit. I pointed you to the help to see some of Access's published limitations.....