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
|
|||
|
|||
Table columns
Does anybody know if there is a limit on how many rows and columns are
allowed in an access table? Thanks. |
#2
|
|||
|
|||
Go to help and type "SPECIFICATION"
"Jeff Stroope" wrote in message news Does anybody know if there is a limit on how many rows and columns are allowed in an access table? Thanks. |
#3
|
|||
|
|||
On Mon, 7 Mar 2005 14:13:03 -0800, Jeff Stroope
wrote: Does anybody know if there is a limit on how many rows and columns are allowed in an access table? 255 fields ("columns"), an absurdly high limit (a 60 field table is *extremely* wide). More critically, there's a hard limit of 2000 characters *actually used* in any single record - that is, you can define a table with 255 fields of 100 bytes each, and even put a lot of data into it, but you'll get an error the first time you try to put ten characters into each field. There is no explicit limit on the number of rows; you're limited to 2 GByte (1 GByte for A97 and older) in any single .mdb file. In practice a 10,000,000 row table is getting pretty big. John W. Vinson[MVP] |
#4
|
|||
|
|||
Thanks John.
"John Vinson" wrote: On Mon, 7 Mar 2005 14:13:03 -0800, Jeff Stroope wrote: Does anybody know if there is a limit on how many rows and columns are allowed in an access table? 255 fields ("columns"), an absurdly high limit (a 60 field table is *extremely* wide). More critically, there's a hard limit of 2000 characters *actually used* in any single record - that is, you can define a table with 255 fields of 100 bytes each, and even put a lot of data into it, but you'll get an error the first time you try to put ten characters into each field. There is no explicit limit on the number of rows; you're limited to 2 GByte (1 GByte for A97 and older) in any single .mdb file. In practice a 10,000,000 row table is getting pretty big. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
Converting a table with rows of info into a table with columns | Ernie | Database Design | 8 | June 15th, 2004 01:59 AM |