Re: Access hanging, corrupting, getting me worried

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jamie (filminformation_at_NOSPAMblueyonder.co.uk)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 02:49:00 +0100

Test the mdb on a different PC if possible. If it still crashes then there
is probably some form of corruption afoot, if not then there may be an error
with the installation of Access.

One option would be to try saving each form etc as a text file and then load
them into a new mdb to try to eradicate any corruption. You can do this
using saveastext from the immediate window and loadfromtext to reload them
into the new mdb. If you have a lot of objects it may be quicker to write a
VBA routine to loop through them all.

Jamie
www.jamiessoftware.tk

"Andrew Backer" <abacker_remove_Uspamerz@comcast.dot.net> wrote in message
news:5mshi0ddmfqqsgpj7otlvc9e8nrgdh8ck7@4ax.com...
> I am using A2k, and having quite a few scares with database
> corruption. Making me wonder if access should even be used at all,
> since once again there is no logic to Access' misbehavior.
>
> I have a startup form set, which should load every time I open the db.
> If it doesn't load, I know something is wrong.
>
> Sometimes a recompile will fix it, and it will start loading fine
> again. Other times it will just die, and importing all objects into a
> new databaes will fix it.
>
> It just did it to me again. I have tried to import to a new database,
> but on import it will crash on importing some object, there doesn't
> appear to be any logic to which one. It kept dying on
> "&Relationship", but after I turned off import relationships, it just
> crashed on a random form. If it crashes, I can sometimes make the
> import dialog go away by pressing esc, but I usually can't close the
> database (msaccess process won't quit), but the db window will go
> away.
>
> I get wierd object names in the database I am importing from, like
> "tmprryQryFrLnkFldsCrtn0123456789". I was able to delete the
> relationships in the 'corrupted' database, but after I did I couldn't
> save it.
>
> Any idea what is goin on? This happens quite regularly, and is really
> starting to worry me.
>
> Thanks,
> Andrew Backer
>
> .--------------------------------------
> | Andrew Backer
> | backer_a @ h0tmai1 dot com
> `--

Relevant Pages

  • Re: Access hanging, corrupting, getting me worried
    ... If your FE mdb is large you might consider trying to break it up into ... Be sure to read Tony's page and Allen's page on corruption. ... I have tried to import to a new database,> but on import it will crash on importing some object, there doesn't> appear to be any logic to which one. ...
    (microsoft.public.access.forms)
  • Re: new record shuts database
    ... can either create a new mdb and import all objects into the new mdb or ou ... can use the undocumented decompile. ... Also check Tony Toews' page on corruption - ... > After opening database again, ...
    (microsoft.public.access.forms)
  • RE: Database crashes
    ... That is, is your data in one .mdb and the forms, ... > I can't be very specific I'm afraid about what's causing the crashes but I ... > have a database that is used by two people and is on ... > a network server and it falls over from time to time throughout the day. ...
    (microsoft.public.access.formscoding)
  • Re: Why does form crash navigating records?
    ... NewSysAdmin wrote: ... YOU TONY!!!!!), with a database. ... from the network and knew there was a large possibility of corruption with ... the form crashes and crashes Access 2003. ...
    (microsoft.public.access.forms)
  • Re: Log users
    ... It's not likely you can tell who caused the corruption. ... file in the folder where the mdb is located, that'll tell you who had been ... You might be able to repair/recover the database. ... Microsoft Access MVP ...
    (microsoft.public.access.security)