[AccessD] Strange flickering problem.

I get this on our Terminal server environment when the server is slow and I close something where I have made a change and I have agreed to save changes.  The title bar toggles between two or three windows at about 30 HZ.  Sometimes it takes a couple minutes to save something like a rowsource for a combo.  It only seems to happen when the server is real busy, but we've now got 33 full time users and everyone is told to keep Outlook 2003 open at all times.  In addition, we have a number of other outside users logging in on our server.  Our Server is one of 40 but it is stretched rather thin so I'm getting this flicker with increasing frequency.
 
Jürgen Welz



> From: Erwin.Craps at ithelps.be> > Or a video driver problem. > > > But I have no form open, just running a macro from the database window.> It is only updating tables.> > Thanks,> Bobby> > -----Original Message-----> Subject: Re: [AccessD] [SPAM SUSPECT] Re: Strange flickering problem.> > > There is something about turning screen.update on and off.> (True/False)> > Try calling some form.> Screen.update = false> Run Macro> Open proper form> Screen.update = true> > Joe Hecht> jmhecht at earthlink.net> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid> > Hi Charlotte,> > There is no UI, except for the one in Access. I have the macro open and> I am running it. This is not always happening and it does not do it if> I do not switch away from Access. There really is no flickering> normally. By flickering, I mean EVERYTHING showing from Access is> flickering - the database window, the properties window, the macro> window, and anything else opened in the IDE.> > Bobby> > -----Original Message-----> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte> Foust> > > In my experience, the IDE does tend to flicker when intense execution is> going on, because focus is shifting back and forth from the IDE to the> UI. Why have the IDE open at all if you're running macros?> All you> need for that is the interface and you can build one or more macros to> call other macros, so it's not really necessry to use the immediate> window.> > Charlotte Foust> > > -----Original Message-----> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid> Hey, > Doing some work on-site for a client using Access 2000. I am updating> an existing reports database that uses mostly macros to call queries and> what-not. They want me to do the same (ughhh!). The OS is XP Pro.> Their are local tables and links to SQL tables in the database.> > Anyway, sometimes when I kick off a long running macro (5-10 minutes),> and go to do something else, Excel, email, etc., when I come back to the> Access IDE, it will be flickering very badly. Through task list, I see> 100% CPU, with Access taking maybe 50% and explorer taking up most of> the rest. I have not left it more than about 15 minutes before killing> Access. Task list shows Access as running during this.> After killing> Access the system is back to normal.> > It looks like something is making all of the windows redraw hundreds of> times a second. Even the task list wind (set to on top) flickers some.> > Has anyone else seen this? Have any solutions?> > Thanks,> Bobby
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/