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
|
|||
|
|||
What are the capabilities of Access?
Hi,
I'm wondering what is the maximum space of Microsoft Access? ie How many rows per database, and how many columns wide per database? Thanks! |
#2
|
|||
|
|||
What are the capabilities of Access?
Here's a link to the on-line help topic on 'Access Specifications'.
http://office.microsoft.com/assistan...HP051868081033 -- Brendan Reynolds Access MVP "Jenny1661" wrote in message ... Hi, I'm wondering what is the maximum space of Microsoft Access? ie How many rows per database, and how many columns wide per database? Thanks! |
#3
|
|||
|
|||
What are the capabilities of Access?
No explicit number on row limit...size of the database is capped at 2GB, 255
fields in a table. More specs available in Access help topic: specifications -- Kevin Hill 3NF Consulting http://www.3nf-inc.com/NewsGroups.htm http://kevin3nf.blogspot.com "Jenny1661" wrote in message ... Hi, I'm wondering what is the maximum space of Microsoft Access? ie How many rows per database, and how many columns wide per database? Thanks! |
#4
|
|||
|
|||
What are the capabilities of Access?
Yeah, I have seen that already, but I can't seem to locate the number of rows
per database in those numbers. I need to know because I have a excel and have a database too large to fit in one tab. I want to purchase Access if it has sufficient row space. Thanks again "Brendan Reynolds" wrote: Here's a link to the on-line help topic on 'Access Specifications'. http://office.microsoft.com/assistan...HP051868081033 -- Brendan Reynolds Access MVP "Jenny1661" wrote in message ... Hi, I'm wondering what is the maximum space of Microsoft Access? ie How many rows per database, and how many columns wide per database? Thanks! |
#5
|
|||
|
|||
What are the capabilities of Access?
On Fri, 27 Oct 2006 12:23:02 -0700, Jenny1661
wrote: Hi, I'm wondering what is the maximum space of Microsoft Access? ie How many rows per database, and how many columns wide per database? Thanks! If you have Access installed, look for help on Specifications. There is no explicit limit on the number of rows; any single .mdb file is limited to 2 GByte. A table can have no more than 255 fields (an absurdly huge limit for any properly normalized table structure, 50 fields is a *very* wide table); more subtly, and sometimes more of a real-life problem, you're limited to 2000 characters *actually used* in any single record. This can be nasty because you can easily create a Table with 20 fields, each a 255-byte Text field; happily put data into it for months; and then get the error when some verbose date actually *uses* all the space in those fields. In practice, I know of Access databases handling upwards of 10,000,000 rows in the largest table. A million or so is not uncommon. John W. Vinson[MVP] |
#6
|
|||
|
|||
What are the capabilities of Access?
millions....way more than Excel will ever dream of holding
There is no hard coded limit -- Kevin Hill 3NF Consulting http://www.3nf-inc.com/NewsGroups.htm http://kevin3nf.blogspot.com "Jenny1661" wrote in message ... Yeah, I have seen that already, but I can't seem to locate the number of rows per database in those numbers. I need to know because I have a excel and have a database too large to fit in one tab. I want to purchase Access if it has sufficient row space. Thanks again "Brendan Reynolds" wrote: Here's a link to the on-line help topic on 'Access Specifications'. http://office.microsoft.com/assistan...HP051868081033 -- Brendan Reynolds Access MVP "Jenny1661" wrote in message ... Hi, I'm wondering what is the maximum space of Microsoft Access? ie How many rows per database, and how many columns wide per database? Thanks! |
#7
|
|||
|
|||
What are the capabilities of Access?
There is no restriction on the number of rows.
-- Brendan Reynolds Access MVP "Jenny1661" wrote in message ... Yeah, I have seen that already, but I can't seem to locate the number of rows per database in those numbers. I need to know because I have a excel and have a database too large to fit in one tab. I want to purchase Access if it has sufficient row space. Thanks again "Brendan Reynolds" wrote: Here's a link to the on-line help topic on 'Access Specifications'. http://office.microsoft.com/assistan...HP051868081033 -- Brendan Reynolds Access MVP "Jenny1661" wrote in message ... Hi, I'm wondering what is the maximum space of Microsoft Access? ie How many rows per database, and how many columns wide per database? Thanks! |
#8
|
|||
|
|||
What are the capabilities of Access?
On Fri, 27 Oct 2006 12:40:02 -0700, Jenny1661
wrote: Yeah, I have seen that already, but I can't seem to locate the number of rows per database in those numbers. I need to know because I have a excel and have a database too large to fit in one tab. I want to purchase Access if it has sufficient row space. Thanks again Access can hold a thousand times as many records as an Excel spreadsheet, more or less depending on total database size. BUT!!!! Access is emphatically *not* Excel on Steroids. Excel is a spreadsheet, the best of the genre; Access is a relational database. THEY ARE DIFFERENT and require different logic and different design. If your only purpose for moving to Access is to get a bigger spreadsheet, you'll be very frustrated. If you recast your application as a properly designed, properly normalized database application, you'll likely be pleased - but it will be a considerable amount of work. John W. Vinson[MVP] |
#9
|
|||
|
|||
What are the capabilities of Access?
Jenny,
I agree with John here. You need to work out whether you need a spreadsheet or a database. If it is database functionality that you need, then Access is the way to go. If it turns out that it is actually spreadsheet functionality that you need, something to take into account is that Excel 2007 is just around the corner, with provision for a million rows per worksheet. -- Steve Schapel, Microsoft Access MVP John Vinson wrote: Access is emphatically *not* Excel on Steroids. Excel is a spreadsheet, the best of the genre; Access is a relational database. THEY ARE DIFFERENT and require different logic and different design. |
#10
|
|||
|
|||
What are the capabilities of Access?
"John Vinson" wrote in message
In practice, I know of Access databases handling upwards of 10,000,000 rows in the largest table. A million or so is not uncommon. I'm working on one right now with over 15.5 million rows in the most detailed table. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
|
Thread Tools | |
Display Modes | |
|
|