Rocky Smolin
rockysmolin at bchacc.com
Fri May 1 15:15:38 CDT 2009
Lambert: He has other redeeming qualities. Nice speaking voice for example. And he reads to her. These benefits cannot be minimized. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Friday, May 01, 2009 1:10 PM To: 'Access Developers discussion and problem solving' Cc: 'Janet Erbach' Subject: Re: [AccessD] Form corruption Janet, Sounds more like he's an out-house waste of space: 100% of the time he has no answer! What else does he consult on? As to your problem. The copy you are developing on: is it stored on a network drive? Do you get the same issues if you work on a copy on your local hard drive? What I'm driving at is that perhaps you have a bad network connection and that is causing the trouble. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Janet Erbach Sent: Friday, May 01, 2009 3:44 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Form corruption Yes, I do have an in-house consultant. (Actually, since he's not on-site does that make him an 'Out-house consultant'?) But half the time he says "Ask the forum!! That's what they're for!!" and the other half he says "Hell if I know, honey!" The compact/repair/compile doesn't seem to help. But I haven't tried the export yet - so I'll try that next. Thank you, sir! Janet On Fri, May 1, 2009 at 2:35 PM, Rocky Smolin <rockysmolin at bchacc.com> wrote: > My first move would be compact and repair. After that - decompile. > After that, create a new mdb and import all the objects. > > If you're unsure about any of these I believe you have an in-house > consultant to provide tech support. > > Rocky > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Janet > Erbach > Sent: Friday, May 01, 2009 12:19 PM > To: Access Developers discussion and problem solving > Subject: [AccessD] Form corruption > > Hello all - > > We manage our order processing/shipping/product inventory using an > access database application developed by some guys in Pennsylvania. I > have created a dozen custom functions within this app that have > allowed me to do things that the original app didn't include. But > form corruption sneaks up on me far more frequently than seems normal. > > It seems to happen most when I've copied a form that I already > created and use that as the starting point for a new form. I'll > notice that my response time starts to seriously degrade - I click on > an object and it's seconds before I can move it or edit it. I'll save > the form and my screen will go blank while it saves, which takes > longer than normal. When that starts to happen I'll compact and > repair my database and re-compile all my code just to clean things > up...but it doesn't seem to help. Finally it gets to the point where > I'll try to open the form in design mode and get one of two > behaviors: 1) a message box saying there aren't enough system > resources to complete the operation or 2) NOTHING HAPPENS - the form > won't run, won't open - nothing. > > Is there something I can do to salvage these corrupt items? Should I > not be using a copy of a form as the basis for a new one? Could it be > related to bloat? I'm making these changes in the front end database > on my PC...The front end on the other pcs here are usually around 55 > MB, but on mine it bloats up to around 290 - and even after > compact/repair it only shrinks to about 170. Granted, I have a few > objects, forms, and tables that are not installed on the other front > ends - but it seems like my front end shouldn't be THAT much heftier! > > Any suggestions? > > > Janet Erbach > IT Administrator > Natural Healthy Concepts > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com