|
| 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
June 17th, 2005, 08:55 AM
|
|||
|
|||
Record limit in access
Hi,
What is maximum record limit in access database (in one table and all tables)? I have database which will have over 500.000 records in one table. Is this too much for access? I am beginner  Thanks in advance 
|
|
#2
June 17th, 2005, 11:09 AM
|
|||
|
|||
|
There is no maximum number of rows. The only maximums Access has is the
total size of the MDB file cannot exceed 2 Gb (1 Gb in Access 97 and earlier), and the size of a single record cannot exceed 2000 characters. I've worked with tables having in excess of a million rows. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Mark" wrote in message ... Hi, What is maximum record limit in access database (in one table and all tables)? I have database which will have over 500.000 records in one table. Is this too much for access? I am beginner Thanks in advance
|
|
#3
June 17th, 2005, 11:30 AM
|
|||
|
|||
|
Thanks, thats good
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Which identity? | Richard | Running & Setting Up Queries | 1 | April 27th, 2005 02:58 PM |
| strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
| is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |
| Access License In Terminal Server | JIM.H. | General Discussion | 9 | July 19th, 2004 12:32 AM |
| Conversion of excel vba code to access vba | filnigeria | General Discussion | 5 | July 15th, 2004 02:23 AM |
Linear Mode
