|
| 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
January 31st, 2009, 07:00 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
what is the maxmun number of records in access 2003
i am disigening a database for my clints, there are more than 50000 clint so
i am asking if there is a record limit in access 2003 or i can enter with no limites 
|
|
#2
January 31st, 2009, 01:19 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
what is the maxmun number of records in access 2003
Yes, there is a limit. No, the limit isn't related to the number of
records. Each record has a limit of approximately 2000 bytes, if I recall correctly. Each Access database file has a limit of 2 Gbytes, if I recall ... Check Access HELP, look for "specifications" for the numbers relevant to your version. -- Regards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ "megapluskha" wrote in message ... i am disigening a database for my clints, there are more than 50000 clint so i am asking if there is a record limit in access 2003 or i can enter with no limites
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
