how many records can I have in an Access Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
*
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Tables 3
How many records can an Access table hold 5
Can't record field from Combo 18
Can I open the source record stored in a Multiple value Combo box field, Access 2007 2
how many records can an access database hold? 3
How many fields can you have in an access 2007 database 2
Is there any way I can find out how many rows in a combo box? 3
how many records can Microsoft Access hold? 1

Back
Top