If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
number of records
What is the maximum number of records that can be in an
Access table. I have one list with 800,000 records then I want to add another 800,000 records to it. So will an access table allow 1,600,000 records. |
#2
|
|||
|
|||
Jaime,
Access does not have a specific limit to the number of records a table can contain. It's more of a limit on the size of the access database. I think it's about 1 mb. If your records are small (few columns and short in length), you can have more records than if they are long. If you find you are getting close to the limit, you can have 1 database that contains your table, and link the table to another database that contains your queries and reports, etc. Hope this helps. -----Original Message----- What is the maximum number of records that can be in an Access table. I have one list with 800,000 records then I want to add another 800,000 records to it. So will an access table allow 1,600,000 records. . |
#3
|
|||
|
|||
Les wrote:
Jaime, Access does not have a specific limit to the number of records a table can contain. It's more of a limit on the size of the access database. I think it's about 1 mb. If your records are small (few columns and short in length), you can have more records than if they are long. If you find you are getting close to the limit, you can have 1 database that contains your table, and link the table to another database that contains your queries and reports, etc. Hope this helps. -----Original Message----- What is the maximum number of records that can be in an Access table. I have one list with 800,000 records then I want to add another 800,000 records to it. So will an access table allow 1,600,000 records. . You have some decimal places displaced. Current versions of Access ( 2000 up ) will work to 2 Gb file size. Search on "specifications" in your version help file for a full set of the limitations. -- Regards, Adrian Jansen adrianjansen at internode dot on dot net Design Engineer J & K Micro Systems Microcomputer solutions for industrial control Note reply address is invalid, convert address above to machine form. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I limit the number of records in a query. | rnprice | Running & Setting Up Queries | 2 | August 31st, 2004 04:27 PM |
Limiting the number of records that can be created | Ant | General Discussion | 2 | June 23rd, 2004 07:09 AM |
Maximum number of records | Tom | General Discussion | 2 | June 11th, 2004 10:42 PM |
Maximun number of the records in MS Access | Nam | General Discussion | 2 | June 7th, 2004 09:49 PM |