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!
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!