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
|
|||
|
|||
finding out table size
I have had no trouble finding out that Access 2000 and 2003 have a 2GB
limit on table size. Now, how does one go about finding out how large a table is. right click properties doesn't reveal this Paris |
#2
|
|||
|
|||
finding out table size
"Paris" wrote in
news I have had no trouble finding out that Access 2000 and 2003 have a 2GB limit on table size. Now, how does one go about finding out how large a table is. right click properties doesn't reveal this It really doesn't matter how big a table is -- it just has to fit inside the .mdb file. In any case, it's probably meaningless, since it's not helpful to store a table without its indexes, relational constraints, property sheets, and so on; which are presumably all scattered throughout the file. Why do you care how big the table is? Tim F |
#3
|
|||
|
|||
finding out table size
You could do some maths on the size of a record and multiply by number of
rows - but i seem to remember that there is an analysis tool - tools-analyze table that should give you what you need. You may need to install it from the CD if you have not already done so. "Tim Ferguson" wrote in message ... "Paris" wrote in news I have had no trouble finding out that Access 2000 and 2003 have a 2GB limit on table size. Now, how does one go about finding out how large a table is. right click properties doesn't reveal this It really doesn't matter how big a table is -- it just has to fit inside the .mdb file. In any case, it's probably meaningless, since it's not helpful to store a table without its indexes, relational constraints, property sheets, and so on; which are presumably all scattered throughout the file. Why do you care how big the table is? Tim F |
#4
|
|||
|
|||
finding out table size
Tim,
Thanks. I'll give it a whirl. In the mean time I've simulated the table size over a year and it's still well below 2GB....no real issue anymore. Paris "BMW" wrote in message ... You could do some maths on the size of a record and multiply by number of rows - but i seem to remember that there is an analysis tool - tools-analyze table that should give you what you need. You may need to install it from the CD if you have not already done so. "Tim Ferguson" wrote in message ... "Paris" wrote in news I have had no trouble finding out that Access 2000 and 2003 have a 2GB limit on table size. Now, how does one go about finding out how large a table is. right click properties doesn't reveal this It really doesn't matter how big a table is -- it just has to fit inside the .mdb file. In any case, it's probably meaningless, since it's not helpful to store a table without its indexes, relational constraints, property sheets, and so on; which are presumably all scattered throughout the file. Why do you care how big the table is? Tim F |
Thread Tools | |
Display Modes | |
|
|