How to find size of Access objects?

[Greg]

Hi all, I appreciate any help you may have.

Is there a way to determine the size of all the objects
in my MDB? Size in KB, bytes, whatever. I just would
like to know which items are taking up the most space in
my MDB.

I have Access XP with an SQL Server backend. I have at
least 2000 objects in my 115MB MDB file, in which I
distribute to each client. The majority of the objects
are linked tables and queries. But there are many
modules, local tables, and forms too. So many objects
make it difficult to find and manage them.

My objective here is to reduce the size of my MDB and
make the client more efficient. I have tried the compact
and repair, which reduces the size by only a few MB. I
tried a /decompile switch on the mdb, and that only made
the file bigger! I am not sure what to do next. I know
there are many objects that are not being used now, that
have not been removed over years of development. If I
could only see which ones are the largest, I would start
with them, and see if they are needed.

Any help is appreciated! Thanks!

 

[Douglas J. Steele]

There's really no easy way to do it. You try could creating a new database,
and import the objects into that new database one at a time, checking the
size of the new database after each import.

If you suspect that there's code that's not being used, take a look at FMS
Total Access Analyzer http://www.fmsinc.com/products/analyzer/index.html

 

[Guest]

Cool! Thanks! I think I'll have to get that Analyser!

But... If the analyser software does not show me object
sizes, I would still really like to see just how much
room each object is using? I am not going to do a single
object import for over 2000 objects. I'd rather just
leave them there.

Let's say I have a report in there, that is used maybe
once a month by one user. By all acounts it's a valid
object, not orphaned. But that object has large pictures
in it, and the report is using 5 or 6 MB of my mdb. How
would I know which object this is? How would I know that
a user is even using it? If I knew what the object sizes
were, I could check them out and remove them or redesign
them.

I'll check out he analyser though, maybe it has exactly
what I need.

Thanks!

 

[itsfrommehehe]

--
HHEHEH IM FROM BURNLEY,we are the lads !!

There's really no easy way to do it. You try could creating a new database,
and import the objects into that new database one at a time, checking the
size of the new database after each import.

If you suspect that there's code that's not being used, take a look at FMS
Total Access Analyzer http://www.fmsinc.com/products/analyzer/index.html