Fully Compiled State

[Romper]

Hi all,
Every time I open my database if the first thing I do is run Performance Analyzer for VBA Project I get the following suggestion :-

"Application: The application is not saved in a fully compiled state"

Where I'm confused is that I can go into Visual Basic, select Debug, and select Compile Stamp Collection (Stamp Collection being the database name) at the end of each database use and then save, but next time I open the database and run the Analyzer, I'm back to square one.

Is this normal? Is there an auto compile setting or something that I should have selected? What would be causing this or is it not something to worry about?

Please help.

 

[mdlueck]

Which version of Access are you referring to?

Perhaps try these steps with a copy of the database and see if it improves the behavior:

NT Command Script and Documented Steps to Decompile / Compact / Compile an Access DB
http://www.access-programmers.co.uk/forums/showthread.php?t=219948

 

[Romper]

Sorry, Access 2007

Thanks, will check out the link.

 

[Romper]

Hi mdlueck,
I have downloaded the script and unzipped to the same folder as the DB. I just need clarification on which parts of the script I need to edit before running. Obviously, I need to edit SET DBPATH.

I'm also guessing that I need to edit SET DBFILE but I've noticed that in your example this line has _FE added to it in difference to the DBpath of just Fandango.

The two lines under SETDBfile are what confuse me as the are worded differently also, how should I edit these?

My database is in :-
Documents/Dave's Collection/New Collection. I am running Access 2007 on Vista OS

Could you kindly show me which lines should be edited and what exactly they should look like as playing with a script is not something I've done before.

I would really appreciate your help.

 

[mdlueck]

Obviously, I need to edit SET DBPATH.

Ja, set DBpath to what ever is correct for your system.

DBdrive needs to be what ever the correct drive letter is.

I'm also guessing that I need to edit SET DBFILE but I've noticed that in your example this line has _FE added to it in difference to the DBpath of just Fandango.

The two lines under SETDBfile are what confuse me as the are worded differently also, how should I edit these?

There are multiple DBfile lines as I unREM the correct line to clean up that DB file. The REM lines will not get run... REM = Remark.

Could you kindly show me which lines should be edited and what exactly they should look like as playing with a script is not something I've done before.

All the more reason to run this script against the DB file COPY in a separate "test" directory until you get the hang of it!

 

[Romper]

So I set DBpath & DBdrive to what I need and delete the other DBfile lines, is that correct?
Please give me more information as I'm not sure about this.

 

[mdlueck]

So I set DBpath & DBdrive to what I need and delete the other DBfile lines, is that correct?

If you mean the REM'ed DBfile lines, then sounds correct. Go ahead and give it a try.

 

[boblarson]

As far as I know, the only time the database file is saved in a fully compiled state would be as an MDE or ACCDE file.

 

[mahenkj2]

If while during distribution your going to use accde format, you need not worry about this message at least. You may have seen that other kind of errors if you fix, they never reappear (like fixing Index...)

I also think that you need not run Analyze Performance every time you open a database. When you are developing the dB, you should run this whenever you make some changes, so if you have any lags somewhere, you can easily come to know and fix before growing infinitely.

 

[Romper]

Thank you,

That's a load off my mind. It's only since I added code to my forms and I was worried I might have done something wrong!
Cheers.