Re: Corruption - how to MAKE it happen?

"(PeteCresswell)" <x@xxxxxxxxx> wrote in
news:86nf035vubm6d2kvo11r8fan18rq3tuv0n@xxxxxxx:

Per Doug:
Another part of the problem is that the application is used
24x7x365, so to compact/repair, I need to kick users out of the
system.

It's just that I *really* have this feeling that the corruption is
caused by people starting up the program (which takes a LONG
time), then deciding "You know what? I don't have time for
this..." and they give it the "3-Fingered Salute".

Sounds like a textbook case for moving the back end over to SQL
Server.

Anybody else agree?

Well, the startup issues aren't, but the 24/7 requirement certainly
is.

Any idea why it takes so long to start up? Might be some other
issues there...

Obviously if you've designed your app so that it takes so long to
load that users give up, it's *your* fault if they are corrupting
the database by killing the process. The easiest way to fix it is
judicious use of DoEvents so that something happens onscreen
periodically to tell them that the app is loading. I recently added
an unnecessary splash screen with 'Please wait while program loads"
before the switchboard comes up (when previously the the blank
Access window was all that was visible), and the users said "Oh!
You've done something to speed up the load time!" Nothing actually
changed behind the scenes -- all that changed was what users were
seeing, and it made them feel like the app was loading more quickly.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Mobile Development for WM 5 with one main exe controlling mult
    ... I'm trying to convince them with what you said about the load strategy, ... it could be due to the fact that all the loading are done ... App size has nothing ... split the whole program from one exe to multiple. ...
    (microsoft.public.pocketpc.developer)
  • DirectX 8 wizard code and a background image during game load?
    ... While my app is running through InitDeviceObjects to load my game I want to ... put up a image on the screen from a .jpg showing that the game is loading. ...
    (microsoft.public.win32.programmer.directx.graphics)
  • Re: DirectX 8 wizard code and a background image during game load?
    ... You gotta load the JPEG image first and blit that on the client DC. ... display JPEG files in a normal VC app will be of much help... ... > put up a image on the screen from a .jpg showing that the game is loading. ...
    (microsoft.public.win32.programmer.directx.graphics)
  • Pin Wheel For Loading
    ... My app has a form that takes a while to load. ... As it is loading, the screen is a cluttered with half drawn controls. ...
    (microsoft.public.pocketpc.developer)
  • Re: Reprise: Pended IOCtrl + LoadLibrary == Deadlock?
    ... >3) launching msdev.exe from the shell and from within windbg. ... >load (from within msdev) ionwizrd.exe ... When I hit F5 to run my app the following occurs: ...
    (microsoft.public.development.device.drivers)