how many records can I have in an Access Database

S

steve Jones

Making a databse to hold titles of songs for a radio station in the
philippines using vb 6 the combo box will only allow 32000 plus then falls
over, I have over 800000 song titles to register for the libray can anyone
help me oradvise me please thank you
 
S

strive4peace

Integer, Long Integer ranges
---

Hi Stgeve,

sounds like you are using an Integer instead of a Long Integer as your
primary key...

Integer range: -32,768 to 32,767
Long Integer range: -2,147,483,648 to 2,147,483,647

An autonumber is a Long Integer data type


Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
D

Dave F

You can have millions of records in an Access db. Its capacity is generally
more constrained by RAM than by an absolute limit in the number of records.

Dave
 
I

Ihar

Is the capacity not restrained by the 2GB file limit on access databases,
something I was hoping would of been lifted or increased with 2007.
 
Top