Decompile ?

  • Thread starter Thread starter Chaster
  • Start date Start date
C

Chaster

I have a Access 2K mdb that just keeps growing. It's 20,808 right now.
Maybe 30 forms, 100 queries, 40 reports, and 4 modules.

All tables are linked from other mdb's.

I have read articles on decompling but just don't understand what needs to
be done to accomplish this.

My msaccess.exe file is located in
D:\Office2K\Office\msaccess.exe

The file I want to decompile is in
F:\startcode.mdb

Could someone help me with this or point me in a direction that might help
me to understand the process?

TIA
 
Chaster said:
I have a Access 2K mdb that just keeps growing. It's 20,808 right
now. Maybe 30 forms, 100 queries, 40 reports, and 4 modules.

All tables are linked from other mdb's.

I have read articles on decompling but just don't understand what
needs to be done to accomplish this.

My msaccess.exe file is located in
D:\Office2K\Office\msaccess.exe

The file I want to decompile is in
F:\startcode.mdb

Could someone help me with this or point me in a direction that might
help me to understand the process?
Click to expand...

First make a backup copy of your database and confirm that the backup is
good. Then click the Start button on the task bar, choose Run... from
the menu, and in the "Run" dialog box, type

D:\Office2K\Office\msaccess.exe /decompile F:\startcode.mdb

and click OK. I'm not sure whether you'll get any notice, in this
Access version, that the decompile was performed. Anyway, after it's
done, recompile your database and save the project.
 
Before you do try and de-compile, did you and do you compact the database on
a regular bases to clear out and re-claim un-used space?

the frequency of compacting is going to depend on how much data and "churn"
you application has.

I have a access application with 160 forms, 26,000 lines of code, 60
reports, and 178 queries.

The whole application is less just over 6 megs in size. When I turn it into
a mde (for the users to use), the the whole size drops below 6 megs, and I
can even zip the whole thing on to a floppy.

I would go tools->compact and repair first. You may not need to try the
de-compile option. Note that the de-compile is a un-documented feature, and
should not be used without some hesitation and caution.
 
Dirk Goldgar said:
and click OK. I'm not sure whether you'll get any notice, in this
Access version, that the decompile was performed. Anyway, after it's
done, recompile your database and save the project.
Click to expand...

Then I'd compact it.

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
 
Chaster said:
I have a Access 2K mdb that just keeps growing. It's 20,808 right now.
Maybe 30 forms, 100 queries, 40 reports, and 4 modules.
Click to expand...

Silly question. Have you compacted it?

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
 
Dear Albert:
I have a access application with 160 forms, 26,000 lines of code, 60
reports, and 178 queries.
Click to expand...

26,000 lines of code... Yikes! Reading things like this always leave me
shaken and send me off whimpering into the night... I remember reading on
Tony Toews's site about the number of forms and lines of code he had
written - I had to take quite a bit of time off of my little Access project
and go back and play with my old DOS batch files just to build up my
confidence again! <g>

Just out of idle curiosity ( is there any other kind of curiosity, I
wonder?), how long did all that take to create?

Cheers!
Fred Boer
 
It ain't the number of lines of code....I've found that the numbers add up
quickly!

But keeping the db below 6 MB with that many forms and reports....now that's
impressive!
 
Fred Boer said:
26,000 lines of code... Yikes! Reading things like this always leave me
shaken and send me off whimpering into the night... I remember reading on
Tony Toews's site about the number of forms and lines of code he had
written -
Click to expand...

The numbers for the one MDB at my clients site have increased by about
50% since you emailed me. I updated them a month or two ago on my
website.
I had to take quite a bit of time off of my little Access project
and go back and play with my old DOS batch files just to build up my
confidence again! <g>
Click to expand...

Ummm, I'm trying to recall the size of the main DOS batch file which
ran my Fidonet BBS. I think the file was about 50K or so and was over
1000 lines long.
Just out of idle curiosity ( is there any other kind of curiosity, I
wonder?), how long did all that take to create?
Click to expand...

Mine took 3600 hours.

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
 
Dear Tony:
The numbers for the one MDB at my clients site have increased by about
50% since you emailed me. I updated them a month or two ago on my
website.
Click to expand...

Now, come on Tony... you are going to be sending back to rehab if you keep
this up! said:
Ummm, I'm trying to recall the size of the main DOS batch file which
ran my Fidonet BBS. I think the file was about 50K or so and was over
1000 lines long.
Click to expand...

Great... can't even take comfort in the pathetic batch files this time!!
Mine took 3600 hours.
Click to expand...

Did you get a washroom break? ;)

Best wishes!
Fred
 
Chaster said:
One form has a internet control active x.
maybe thats it.
Click to expand...

No because it keeps those external unlike graphics which are embedded
and converted to bmps.

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
 
Chaster said:
Using the decompile given me by one of the respondents did bring it down to
16 megs which still seems large.
Click to expand...

Agreed. Then I'd also try importing into a new MDB.

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
 
Back
Top