[AccessD] The form just won't save.

Max max at sherman.org.uk
Tue Nov 23 11:52:35 CST 2004


Hi Chris,
What sometimes works is to save the form as a copy.  Select the form in the
db window (right-click) and then copy it to a new form (right-click again
and give it a new name).  The new one often gets copied over without the
offending corrupted byte!
Also, as Lambert says, import it into a new DB, but BEFORE you copy the
offending form, save a backup of what you have copied so far.  
You could also try my program which copies all selected objects as text and
you can then import them from text into a new DB (forms, reports, queries,
modules, etc).  You will find it on Rogers site.   It is called
EATBloatV2.mdb (Extract as Text - defeats DB bloat).

Max Sherman

  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: 23 November 2004 17:24
To: 'Access Developers discussion and problem solving'; 'Christopher
Hawkins'
Subject: RE: [AccessD] The form just won't save.

Sounds like you need to import all the objects in the db to a fresh, empty
mdb file. 

I'd start by importing everything but the problem form (and also leave
behind the MSYS* tables, Access will build them afresh). Then try importing
the problem one. I guess that it will refuse to import as it has become
corrupted. You will then have to rebuild it from scratch or import it from a
backup copy of the application.

Lambert

> -----Original Message-----
> From:	accessd-bounces at databaseadvisors.com
> [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of Christopher 
> Hawkins
> Sent:	Tuesday, November 23, 2004 11:56 AM
> To:	accessd at databaseadvisors.com
> Subject:	[AccessD] The form just won't save.
> 
> I have an Access 2000 mdb file.  Within this file is a particular 
> form.  Whenever I try to save changes to the form's module, it just 
> won't save.  It hourglasses on me forever and eventually returns a 
> 'Not Responding' message.
> 
> I have decompiled it.  I have recompiled it.  I have compacted it.  I 
> have repaired it.
> 
> I do not know what else to do.
> 
> Plus I'm working with a fever.  Ack.
> 
> Thoughts?
> Respectfully,
> 
> Christopher Hawkins
> Software Developer
> (559) 687-7591
> http://www.christopherhawkins.com
> 
> 
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.798 / Virus Database: 542 - Release Date: 18/11/2004
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.798 / Virus Database: 542 - Release Date: 18/11/2004
 




More information about the AccessD mailing list