While in the mdb file, hit keys [CTRL] and [G]. This opens the immediate window, which also opens the VBA window. If an application is uncompiled, then the computer must read each line of code as it needs it, which slows everything down. A compiled version is read by the computer much faster. I have had issues where the computer was slower than normal, and compiling it helped address the speed issue.
To compile the code, while in the VBA window, click on menu option Debug, and then click the first choice, which is compile (database name). If no errors exist in the code and all of the references are correct, then the application should compile without issue. Otherwise, you will have to fix the code errors and reference issues. Hope this helps. TJ --- torres0157 <[EMAIL PROTECTED]> wrote: > T.J. > what do you mean compile the application? > just want to learn and know more. > > A.T. > > > --- In AccessDevelopers@yahoogroups.com, Trent Johnsey <[EMAIL PROTECTED]> > wrote: > > > > Have you compiled the application? > > TJ > > > > --- Cathy Jupp <[EMAIL PROTECTED]> wrote: > > > > > > > > I've just upgraded from 2000 to 2003 and I'm noticing a > significant drop in > > > performance. I have the server backend/workstation frontend > setup as > > > recommended to me here a couple of years ago, and I have to say > that it's > > > made a world of difference, so retroactive thanks for that. But > mods that > > > used to take seconds are now taking much longer. For example, > on opening a > > > report in design mode it takes quite a few seconds for the > properties box to > > > be populated, whereas under 2000 it was virtually instant. I've > copied the > > > database in question onto my C drive to make sure it isn't a > network issue, > > > but that made no difference. Is there anything obvious I could > look at, or > > > is 2003 just slower than 2000? > > > Cheers > > > Cathy > > > > > > ps the users have noticed a difference too, so it's not just a > development > > > issue. > > > > > > > > > > > > > __________________________________ > > Yahoo! Mail - PC Magazine Editors' Choice 2005 > > http://mail.yahoo.com > > > > > > > __________________________________ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
