|
| 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
April 4th, 2005, 01:25 PM
|
|||
|
|||
record limit
hi,
How many records can I have in ms access? what is the limit. thanks 
|
|
#2
April 4th, 2005, 01:29 PM
|
|||
|
|||
|
There is no limit to the number of records in a table.
The practical limit is that the database size cannot exceed 2GB. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "arian" wrote in message ... hi, How many records can I have in ms access? what is the limit. thanks
|
|
#3
April 4th, 2005, 05:06 PM
|
|||
|
|||
|
On Mon, 4 Apr 2005 05:25:09 -0700, "arian"
wrote: hi, How many records can I have in ms access? what is the limit. thanks No specific limit, as Allen says; in practice, about the largest production Access database table that I know of has some 20,000,000 records. Tens to hundreds of thousands of records are quite routine and managable. John W. Vinson[MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Record Limit in a datasheet? | Indiansquib | Using Forms | 2 | November 17th, 2004 01:27 PM |
| no current record error | Dave Bradshaw | Using Forms | 2 | November 13th, 2004 10:32 AM |
| Avoid Creating A Duplicate Record | Mark | New Users | 4 | May 11th, 2004 01:52 AM |
| Record Limit | Sonia | New Users | 2 | April 29th, 2004 04:36 AM |
| Excel record limit? | Luis Miguel | Setting up and Configuration | 5 | November 21st, 2003 09:59 AM |
Linear Mode
