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