One of my larger Access97 systems is now 12mb of code: queries, forms,
reports, and modules (with a few tiny lookup tables). It also contains 45
links to an Access back-end, and 20 links to a SQL Server db
Just today I replaced 16 subforms used for looking up data with 1 subform
and a little code (ala David Fenton's LookupAdmin system). That helped a
little, but it's still a sizeable program.
Which objects take up the most space? Is there a way to see the individual
object sizes?
8  1765 
Did you compact that front-end after deleting the 16 original subforms? If
you did not, the space hasn't been retrieved. Another source of bloat is
temporary tables (you'll find a method for avoiding that by using a
temporary database to contain the temporary tables, at MVP Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm), and yet another is internal
temporary workspace generated by various actions in Access (one of which is
the running of certain queries).
I doubt that information on which objects take up the most space would be
helpful -- in any case, that information isn't available. Obviously, tables
with lots of records can be the largest objects around, but that should not
be the case in your front-end (unless you are using temporary tables in the
front-end database).
Larry Linson
Microsoft Access MVP
"DFS" <no****@nospam.com> wrote in message
news:10*************@corp.supernews.com... One of my larger Access97 systems is now 12mb of code: queries, forms,
reports, and modules (with a few tiny lookup tables). It also contains 45
links to an Access back-end, and 20 links to a SQL Server db
Just today I replaced 16 subforms used for looking up data with 1 subform
and a little code (ala David Fenton's LookupAdmin system). That helped a
little, but it's still a sizeable program.
Which objects take up the most space? Is there a way to see the
individual object sizes?
"DFS" <no****@nospam.com> wrote: One of my larger Access97 systems is now 12mb of code: queries, forms,
reports, and modules (with a few tiny lookup tables).
When's the last time you did a decompile? See Decompile or how to reduce Microsoft
Access MDB/MDE size and decrease start-up times http://www.granite.ab.ca/access/decompile.htm
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
"DFS" <no****@nospam.com> wrote in
news:10*************@corp.supernews.com: One of my larger Access97 systems is now 12mb of code: queries,
forms, reports, and modules (with a few tiny lookup tables). It
also contains 45 links to an Access back-end, and 20 links to a
SQL Server db
Just today I replaced 16 subforms used for looking up data with 1
subform and a little code (ala David Fenton's LookupAdmin system).
That helped a little, but it's still a sizeable program.
Which objects take up the most space? Is there a way to see the
individual object sizes?
Are there any graphics in it? I have seen that bloat things a lot.
I'd recommend that you try creating a brand-new MDB and importing,
and then see how big it is with the objects freshly imported (do a
compact but don't open anything). If it's 8 or 10MBs, then 12 sounds
about right for one that's in use. If it's 4 or 5, then there must
be something wrong with the MDB file (I've seen corruption that is
never removed by a compact that bloats the file significantly, but
that doesn't cause any noticeable problems).
If this new MDB then bloats up, then you've got a design problem.
You shouldn't be writing to any tables in the front end, especially
if you're deleting records from those tables, and you shouldn't be
writing temporary QueryDefs. The jury is out on unnamed using
QueryDefs to open recordsets, which some people say can lead to
bloat and others claim cannot.
Another thing is to convert to an MDE and see what size the MDE
comes out as.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"Larry Linson" <bo*****@localhost.not> wrote in message
news:Wy***************@nwrddc03.gnilink.net... Did you compact that front-end after deleting the 16 original subforms? If
you did not, the space hasn't been retrieved. Another source of bloat is
temporary tables (you'll find a method for avoiding that by using a
temporary database to contain the temporary tables, at MVP Tony Toews'
site, http://www.granite.ab.ca/accsmstr.htm), and yet another is internal
temporary workspace generated by various actions in Access (one of which
is the running of certain queries).
Sure, I did all that. Emptied my temp tables, compacted, etc. It's 12mb
after doing that. I'm not really worried about the size , just curious.
Thanks
I doubt that information on which objects take up the most space would be
helpful -- in any case, that information isn't available. Obviously,
tables with lots of records can be the largest objects around, but that should
not be the case in your front-end (unless you are using temporary tables in
the front-end database).
Larry Linson
Microsoft Access MVP
"DFS" <no****@nospam.com> wrote in message
news:10*************@corp.supernews.com... One of my larger Access97 systems is now 12mb of code: queries, forms,
reports, and modules (with a few tiny lookup tables). It also contains
45 links to an Access back-end, and 20 links to a SQL Server db
Just today I replaced 16 subforms used for looking up data with 1
subform and a little code (ala David Fenton's LookupAdmin system). That helped
a little, but it's still a sizeable program.
Which objects take up the most space? Is there a way to see the
individual object sizes?
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@24.168.1 28.74... "DFS" <no****@nospam.com> wrote in
news:10*************@corp.supernews.com:
One of my larger Access97 systems is now 12mb of code: queries,
forms, reports, and modules (with a few tiny lookup tables). It
also contains 45 links to an Access back-end, and 20 links to a
SQL Server db
Just today I replaced 16 subforms used for looking up data with 1
subform and a little code (ala David Fenton's LookupAdmin system).
That helped a little, but it's still a sizeable program.
Which objects take up the most space? Is there a way to see the
individual object sizes?
Are there any graphics in it? I have seen that bloat things a lot.
No graphics. Lots of forms:
91 forms (2/3 are subforms)
25 ODBC links
20 local tables (all small)
46 Access links
6 modules
106 queries
47 reports (about half are subreports)
It's getting pretty big. I have another system (Access2000) that's even
bigger; it's approaching 20mb.
I'd recommend that you try creating a brand-new MDB and importing,
and then see how big it is with the objects freshly imported (do a
compact but don't open anything). If it's 8 or 10MBs, then 12 sounds
about right for one that's in use. If it's 4 or 5, then there must
be something wrong with the MDB file (I've seen corruption that is
never removed by a compact that bloats the file significantly, but
that doesn't cause any noticeable problems).
Haven't tried a new .mdb. I'm not really worried about the size, just
curious.
If this new MDB then bloats up, then you've got a design problem.
You shouldn't be writing to any tables in the front end, especially
if you're deleting records from those tables,
I disagree.
and you shouldn't be
writing temporary QueryDefs. The jury is out on unnamed using
QueryDefs to open recordsets, which some people say can lead to
bloat and others claim cannot.
Don't use them.
Another thing is to convert to an MDE and see what size the MDE
comes out as.
I always distribute the .mde, and it's about 6mb.
Thanks
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"DFS" <no****@nospam.com> wrote in
news:10*************@corp.supernews.com: "David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@24.168.1 28.74... Another thing is to convert to an MDE and see what size the MDE
comes out as.
I always distribute the .mde, and it's about 6mb.
You mean the source MDB is 12MBs and the resulting MDB is 6MBs?
Wow! That's a huge difference.
Do you have conditional compiling turned off?
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@24.168.1 28.86... "DFS" <no****@nospam.com> wrote in
news:10*************@corp.supernews.com:
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@24.168.1 28.74... Another thing is to convert to an MDE and see what size the MDE
comes out as.
I always distribute the .mde, and it's about 6mb.
You mean the source MDB is 12MBs and the resulting MDB is 6MBs?
The source .mdb is 12mb, and the resulting .mde is 6mb.
Wow! That's a huge difference.
I thought so too, but I haven't ever had any .mde problems.
Do you have conditional compiling turned off?
No. I'll look into it.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"DFS" <no****@nospam.com> wrote in
news:10************@corp.supernews.com: "David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@24.168.1 28.86... "DFS" <no****@nospam.com> wrote in
news:10*************@corp.supernews.com:
> "David W. Fenton" <dX********@bway.net.invalid> wrote in
> message
> news:Xn**********************************@24.168.1 28.74...
>> Another thing is to convert to an MDE and see what size the
>> MDE comes out as.
>
> I always distribute the .mde, and it's about 6mb.
You mean the source MDB is 12MBs and the resulting MDB is 6MBs?
The source .mdb is 12mb, and the resulting .mde is 6mb.
That's a huge difference. Code just doesn't take up that much space,
even in a really code-heavy MDB, so there must be a bunch of
temporary structures being discarded. Wow! That's a huge difference.
I thought so too, but I haven't ever had any .mde problems.
Well, no MDE conversion problems at least indicates that you're not
carrying the obvious kinds of code corruption. Do you have conditional compiling turned off?
No. I'll look into it.
You might want to review MichKa's article on compilation states:
The Real Deal on the /DECOMPILE Switch http://trigeminal.com/usenet/usenet004.asp
Now I'm wondering if you're editing/deleting data in the front end
tables you have alluded to. That will cause bloat.
Of course, if I'm remembering correctly, the bloat doesn't all go
away with a compact?
Very strange!
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Digital Puer |
last post by:
Hi, suppose I have an unsigned long long. I would like to extract
the front 'n' bits of this value and convert them into an integer.
For example, if I extract the first 3 bits, I would get an int...
|
by: NGM |
last post by:
Hello All
When implementing FrontController sample MSDN
I am facing a lot of problems
try implementing the front controller patterm sample provided by microsoft:...
|
by: Alok Jain |
last post by:
Hi,
We are using Front Controller implementation in our DotNet application.
I am trying to hide URL in my application. This is based on Front Controller
model.
I am able to achieve if I do...
|
by: Ashish |
last post by:
Is anyone aware of a good Front Controller Pattern implementation in
ASP.Net, we are developing a new product, and contemplating whether we
should use Front Controller Pattern implementation, due...
|
by: Abhishek Saksena |
last post by:
Hi all,
Can somebody help me what the bhaviour of front method on an empty map.
For some reason calling front on an empty map seems to work with gcc
compiler but not with .NET.
Abhishek
|
by: eight02645999 |
last post by:
hi
wish to ask a qns on strip
i wish to strip all spaces in front of a line (in text file)
f = open("textfile","rU")
while (1):
line = f.readline().strip()
if line == '':
break
print line
|
by: M O J O |
last post by:
Hi,
I have an application where I've implemented a global hotkey, so no matter
what other application is in front (have focus), my app will react when the
key combination is pressed. This works...
|
by: Iain Bishop |
last post by:
I have a simple form with 4 command buttons and 1 label. The label is
sometimes visible and sometimes not. When it is visible I want it to be in
front of the buttons.
I've tried bringing the label...
|
by: John |
last post by:
What is the easiest way to make the contact form show on the front
page. Meaning on want to keep the front html page and when someone
clicks on the contact us link the front page remains the same,...
|
by: =?Utf-8?B?R2lkaQ==?= |
last post by:
Hi,
I asked here yesterday about bringing a form to front with hotkey while
using different application then mine (meaning, when i'm using outlook, and
pressing ALT+T it will bring a form from...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
