[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
>