C
Chris
Ho do I find or calculate the size of an index for a row in a access
database
Regards
Chris Gerhard
database
Regards
Chris Gerhard
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tim Ferguson
Ho do I find or calculate the size of an index for a row in a access
database
1) What is "an index for a row"?
2) In general it's not possible to know the size of anything within a mdb
file, nor is it particularly helpful to know it.
3) As a practical solution, you could (a) compact the db, (b) delete the
object, and (c) recompact the db. Probably not very reproducible, though,
and there is some danger in compacting-and-repairing a non-broken database.
HTH
Tim F
T
TC
A >rough< calculation is to sum the actual or average lengths of the indexed
fields, then multiply by the number of records.
But as the other respondent said, this is not useful information. Why do you
want to know it?
HTH,
TC
fields, then multiply by the number of records.
But as the other respondent said, this is not useful information. Why do you
want to know it?
HTH,
TC
G
Guest
Test
--
T
--
T
TC said:A >rough< calculation is to sum the actual or average lengths of the indexed
fields, then multiply by the number of records.
But as the other respondent said, this is not useful information. Why do you
want to know it?
HTH,
TC