Sign Up |  Live StatsLive Stats    Articles 35,345| Comments 159,791| Members 17,820, Newest waheguruhelpme| Online 218
Home Contact
 (Forgotten?): 
    Sikhism

   
                                                                     Your Banner Here!    

compile/compact/repair frequency

Our Donation Goal : Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters
Goal this month: 400 USD, Received: 35 USD (9%)
Please Donate...
Related Topics...
Thread Thread Starter Forum Replies Last Post
Can't Compact&Repair - corrupt table (help!) Andy C Matthews Information Technology 2 28-Jul-2006 08:39 AM
Compact & Repair Question StuJol Information Technology 2 28-Jul-2006 08:37 AM
Unable to compact/repair database John Information Technology 12 28-Jul-2006 08:32 AM
Unattended Compact Repair CaptainBly Information Technology 2 28-Jul-2006 08:26 AM
Compact and repair MSysCompactError okschlaps Information Technology 0 28-Jul-2006 08:12 AM


Tags
compile or compact or repair, compilecompactrepair, frequency
Reply Post New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!
  #1 (permalink)  
Old 28-Jul-2006, 08:42 AM
Matt K.'s Avatar Matt K.
Guest
 
Posts: n/a
   
   
compile/compact/repair frequency

  Donate Today!   Email to Friend  Tell a Friend   Show Printable Version  Print   Contact sikhphilosophy.net Administraion for any Suggestions, Ideas, Feedback.  Feedback  

Register to Remove Advertisements
I have been browsing this board and notice some posts talking about .mde
files "bloating" in size, slow performance of split access database on
network, etc. Discussion threads usually include mention of
"compact and repair your database"
"compile your VBA code" or "decompile your code then recompile"
I am learning how to develop my database (a2003) as I go and try to refer to
the help file as much as possible. If it was not for this forum, however, I
would never have gotten off the ground with this. Kudos to the contributors.
Maybe this is going overboard, but it has become habit eveytime I add/change
code, File>save; Debug>compile.
And when I am finished working on the db for the day, Tools>Database
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14056-compile-compact-repair-frequency.html
Utilities>Compact and Repair Database.
QUESTION: Is this necessary? Today I notice in MSaccess
Tools>Options>General there is "Compact on close". Also in VBeditor
Tools>Options>General tab is Compile choices. Are these things happening
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14056
without me manually doing them?
I have not split my database and put it in use yet, but will soon... still
developing. I get nervous when I read some of the posts and wonder "will that
happen to mine?" I want to do this right and have a "clean, efficient,
smooth" interface for the users... sort of like a duck on a lake-from the top
it looks calm and graceful; underwater it's feet are going like hell.



 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 28-Jul-2006, 08:43 AM
Albert D.Kallal's Avatar Albert D.Kallal
Guest
 
Posts: n/a
   
   
Re: compile/compact/repair frequency

  Donate Today!  
> Maybe this is going overboard, but it has become habit eveytime I
> add/change
> code, File>save; Debug>compile.


I also do the above....

(I uise the keyboard..and I do this so often, that it is insticnvle now..and
I don't even remember doing this).

The keystrocks I use are

ctrl-s save
alt-d, Enter key (note when you hit alt-d, the debug menu
drops down...and then you whack the enter key.

SNAP, BING, bang!.....I hit the above 3 keystockes one after antoher
ctrl-s, alt-d, whack enter key.

I then often hit alt-f4 to close the wdinow

So, yes, often we devleopers will do a compile after every change. Certanly,
as I done making changes to the code module, I will hiet ctrl-s. This ensure
my code is saved...even if the appcaton where to freezee, or crash...


> And when I am finished working on the db for the day, Tools>Database
> Utilities>Compact and Repair Database.


Yes, again, the above makes sense...and often, this will occur more then
once during the day....

> QUESTION: Is this necessary? Today I notice in MSaccess
> Tools>Options>General there is "Compact on close".

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14056

I don't mind the above....but, often hwen I am in a hurry, or have to close
the appciaton and leave, I don't want it to compact. I think this opten is
better for END USERS that dont' even know to do this. As a intelient
expaonced dvelpoer that you are, then you have your own sense as to when to
do this..

> Also in VBeditor
> Tools>Options>General tab is Compile choices. Are these things happening
> without me manually doing them?


Well, the compile on demand is ok, but it only occurs when you run the code.
Would you not want to find/see syntax errors WHILE you are right there in
the code editor?

Of course, during development, you will hold down the shift key so your
startup settings don't run. You then develop for awhile, and then to test in
"user" mode, you exit..and then re-enter the application without the shift
key bypassed. You will likely do this dance all day long as you run/test as
user mode, and then flip back in to developer mode (shift key used..so you
don't get the main custom menu). So, you can't develop, or really modify
things when you run your application with the startup settings...so you must
shift-by-pass them when you want to work.

And, in fact, I use alt-f4 to exit the application...the mdb file should
still be highlighted in the windows explore..so, then you hit enter key
(and, hold down shift key if you need be). This key stroke sequence and
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14056
exiting and re-entering the application will occur CONSTANTLY all day long
when you are developing.

When you finally have things just right...you create the mde
you plan to distribute...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal


Reply With Quote
   Click Here to Donate Now!

Support Us!
Become a Promoter!
Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh!
ReplyPost New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!

Bookmarks


(View-All Members who have read this thread : 0
There are no names to display.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Tools Search
Search:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

» Gurbani Jukebox
Listen to Gurbani while surfing SPN!
» Active Discussions
sikhism need urgent advice.......
Today 10:03 AM
7 Replies, 87 Views
sikhism Who is "Mohan"?
Today 08:46 AM
22 Replies, 348 Views
sikhism How important is Matha...
Today 08:12 AM
59 Replies, 1,041 Views
sikhism ਨਾਮਾ
Today 06:37 AM
2 Replies, 53 Views
sikhism Sikh Diamonds Video...
Today 04:23 AM
6 Replies, 120 Views
sikhism Are Creator and Creation...
Today 01:30 AM
44 Replies, 2,837 Views
sikhism Herman Hesse,...
Today 00:54 AM
13 Replies, 230 Views
sikhism On a Scale of Most...
Yesterday 21:42 PM
30 Replies, 1,277 Views
sikhism I became victim by...
Yesterday 19:50 PM
0 Replies, 46 Views
sikhism Sikh Books downloads
Yesterday 15:39 PM
2 Replies, 66 Views
sikhism Salok Sheikh Farid ji...
Yesterday 09:35 AM
0 Replies, 47 Views
sikhism In Punjab, three farmers...
Yesterday 05:36 AM
0 Replies, 49 Views
sikhism Supernatural Sikhs, what...
Yesterday 03:45 AM
19 Replies, 416 Views
sikhism Sukhmani Sahib Astpadi...
26-May-2012 22:57 PM
0 Replies, 51 Views
Do You Think You Are...
26-May-2012 09:59 AM
94 Replies, 8,258 Views
» Books You Should Read...
Powered by vBadvanced CMPS v3.2.2

All times are GMT +6.5. The time now is 10:04 AM.
Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.5.2 Copyright © 2004-12, All Rights Reserved. Sikh Philosophy Network


Page generated in 0.33543 seconds with 30 queries