| | |
|
|
|
Access limits |
|---|
| message from Nick on 12 May 2004 |
I have been requested to import a lot of text files into
Access. The number of rows (5 columns) would be in the
millions. Anyone have a guess at the practical max number
of rows I can put in a table?
Thanks,
Nick
|
| Kevin3NF replied to Nick on 12 May 2004 |
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Nick" <nick.randell@xcelenergy.com> wrote in message
news:c22d01c43843$899c1b50$a001280a@phx.gbl...
|
| John Vinson replied to Nick on 12 May 2004 |
You're limited to 2 GByte (2048 MByte) in any single .mdb file. The
largest production Access database of which I am aware has 50,000,000
rows in the largest table. A few million rows in a well-designed
database should be quite practical.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
| Wayne Morgan replied to Nick on 12 May 2004 |
It's not the number of records, its the size of the records. For the limits,
see this link. It is for Access 97 and has a link that will take you to the
same information for Access 2002. It can also be found in the help file if
you search on the word "specifications".
|
|
Archived message: Access limits (MS Access)
