[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