Compile/Decompile questions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike M - 19 Sep 2003 18:16 GMT

I have been trying to understand Access better and have been reading the
different help sites about performance issues. When you Decompile do you
Decompile the front end or the back end? If it is the front end does
this function effect the backend in any manner? After Decompiling do you
need to Compile?
I did not design this DB and know little about doing such things but I
am finding it a necessary part of my job now to learn about it. The
actual designer knows little more than me about it and when asked about
compiling the DB said she never knew of such a feature.

Signature

Mike Moore
Computer Services Technician
Snow Summit Mt. Resort
Office (909) 866-5766 Ext.270
mikemoore@ www.snowsummit.com
Contact info not for share, rent or distribution.

Reply to this Message

Bruce M. Thompson - 19 Sep 2003 22:57 GMT

See:

http://www.databasecreations.com/DatabasePerformanceTips.pdf
http://www.granite.ab.ca/access/decompile.htm
http://www.trigeminal.com/usenet/usenet004.asp?1033

I discourage excessive decompiling as there is some risk of damage that might
not be immediately obvious.

Signature

Bruce M. Thompson, Microsoft Access MVP
bthmpson@mvps.org (See the Access FAQ at http://www.mvps.org/access)

>> NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<

> I have been trying to understand Access better and have been reading the
> different help sites about performance issues. When you Decompile do you
[quoted text clipped - 5 lines]
> actual designer knows little more than me about it and when asked about
> compiling the DB said she never knew of such a feature.

Reply to this Message

Mike M - 22 Sep 2003 16:18 GMT

Well ok thanks, but these pages don't address my questions on weather or
not it effects the front, the back or both.
Or weather or not she had created a DB that uses the VB code and would
require compiling or decompiling.
Mike

| See:
|
[quoted text clipped - 17 lines]
| > actual designer knows little more than me about it and when asked about
| > compiling the DB said she never knew of such a feature.

Reply to this Message

Bruce M. Thompson - 22 Sep 2003 18:42 GMT

> Well ok thanks, but these pages don't address my questions on weather or
> not it effects the front, the back or both.

It affects the file that the decompile is run against, but will have no effect
on tables, queries or macros. Decompile only affects code, so any forms or
reports that contain code will be affected. When decompiling an MDB, *no* other
MDB is affected.

> Or weather or not she had created a DB that uses the VB code and would
> require compiling or decompiling.

If the MDB contains only tables (as in a back-end data file), it has no code. If
the MDB contains forms and/or reports, it likely contains code (at least
wizard-created code related to command buttons and such), but that is not to say
that it will. If an MDB contains no code, nothing will change in the file if you
attempt to decompile it. The latter 2 web pages that I pointed you to contain
information about when to consider decompiling.

Does this answer your questions?

:-)

Signature

Bruce M. Thompson, Microsoft Access MVP
bthmpson@mvps.org (See the Access FAQ at http://www.mvps.org/access)

>> NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<

Reply to this Message

Mike M - 22 Sep 2003 22:22 GMT

Yes it answers the question now... |;0)
Thanks so very much.
Mike

| > Well ok thanks, but these pages don't address my questions on weather or
| > not it effects the front, the back or both.
[quoted text clipped - 19 lines]
| >> NO Email Please. Keep all communications
| within the newsgroups so that all might benefit.<<

Reply to this Message

Bruce M. Thompson - 23 Sep 2003 00:00 GMT

> Yes it answers the question now... |;0)
> Thanks so very much.

You're quite welcome.

:-)

Signature

Bruce M. Thompson, Microsoft Access MVP
bthmpson@mvps.org (See the Access FAQ at http://www.mvps.org/access)

>> NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<

Reply to this Message