Crashing of Access 97

[sjakie.pretpaleis]

The database I'm working in is about 6mb. It consist of a few local
tables, and about 60 linked tables, around 130 queries, 33 forms, 10
reports, 1 macro and 17 modules.

Everytime after I change something in for example a module I close
Access. When I open it, Access crashes. My last change was a new
linked table, a query and a new form. When reopening, crash. Also when
I get the backup and import everything, this happens. Does anyone have
an idea what this is and how it is caused?

Thanks in advance,
Sjakie.

[Tom van Stiphout]

On Tue, 31 Jul 2007 08:15:58 -0000, sj***************@gmail.com wrote:

A97 is very stable, especially with service pack 2 and the latest Jet
service pack installed. You may want to try a different machine to
figure out whether it's your PC or your db.

-Tom.

>The database I'm working in is about 6mb. It consist of a few local
tables, and about 60 linked tables, around 130 queries, 33 forms, 10
reports, 1 macro and 17 modules.

Everytime after I change something in for example a module I close
Access. When I open it, Access crashes. My last change was a new
linked table, a query and a new form. When reopening, crash. Also when
I get the backup and import everything, this happens. Does anyone have
an idea what this is and how it is caused?

Thanks in advance,
Sjakie.

[Brian Graham]

I once had an ODBC link give me grief. It tested ok but I had problems using the link. The solution for this was to create a new ODBC link and get the tables to use this name rather than the old one.

HTH
--
Brian

>><sj***************@gmail.comJuly 31, 2007 4:15 am >>>

The database I'm working in is about 6mb. It consist of a few local
tables, and about 60 linked tables, around 130 queries, 33 forms, 10
reports, 1 macro and 17 modules.

Everytime after I change something in for example a module I close
Access. When I open it, Access crashes. My last change was a new
linked table, a query and a new form. When reopening, crash. Also when
I get the backup and import everything, this happens. Does anyone have
an idea what this is and how it is caused?

Thanks in advance,
Sjakie.

[David W. Fenton]

"Brian Graham" <Gr*****@psac-afpc.comwrote in
news:2f*************************@PRIMUS.CA:

Everytime after I change something in for example a module I close
Access. When I open it, Access crashes. My last change was a new
linked table, a query and a new form. When reopening, crash. Also
when I get the backup and import everything, this happens. Does
anyone have an idea what this is and how it is caused?

Corrupted compiled code. Decompile, compact, recompile and compact
and it will likely go away permanently.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[maxhugen]

Totally agree with David. I have an A97 application still running very
reliably. However, from time to time it gets a burst of Access crashes,
typically when trying to save changes to forms and reports with modules,
&/or standalone modules.

A decompile, followed by a re-compile, then a compact has always fixed
the issue.

I always follow this procedure before releasing an update to the client
as well.

*** Sent via Developersdex http://www.developersdex.com ***

[ARC]

Sometimes, however, an object can become corrupted beyond repair. This would
happen to me a LOT with my development machine once my program got to a
particular size (since access 2007, it doesn't crash much at all, thank
goodness).

Anyway, if the recompiling doesn't help, nor the compact or jetcomp.exe
utility, try this:

* Download the FMS Power Pack for Access 97 from FMS Inc.

* Run the FMS power pack utility under add-ins, and run the Complexity
meter.

FMS will then go through every object, and you can see the objects scrolling
by. Once access crashes, you can see the last object that FMS checked, so
the next object is the culprit. You can then locate a backup of your code,
and import a good copy of the corrupted object, then rename the imported
object so it overwrites the corrupt one. Compact, and then compile, and you
should be good to go.
"maxhugen" <devdex_AT_hugen_DOT_com_DOT_auwrote in message
news:46**********************@news.qwest.net...

Totally agree with David. I have an A97 application still running very
reliably. However, from time to time it gets a burst of Access crashes,
typically when trying to save changes to forms and reports with modules,
&/or standalone modules.

A decompile, followed by a re-compile, then a compact has always fixed
the issue.

I always follow this procedure before releasing an update to the client
as well.

*** Sent via Developersdex http://www.developersdex.com ***

[Sjakies Pretpaleis]

On Jul 31, 8:57 pm, "David W. Fenton" <[e-mail]>
wrote:

"Brian Graham" <[e-mail] innews:2f*************************@PRIMUS.CA:

Everytime after I change something in for example a module I close
Access. When I open it, Access crashes. My last change was a new
linked table, a query and a new form. When reopening, crash. Also
when I get the backup and import everything, this happens. Does
anyone have an idea what this is and how it is caused?

Corrupted compiled code. Decompile, compact, recompile and compact
and it will likely go away permanently.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Hello Brian,

Thanks for your reply. I have been searching in Access for this, but I
can't seem to find it. Where do I find the decompile option?

Thanks agian.
Sjakie.

[Sjakies Pretpaleis]

On Aug 1, 2:13 pm, Sjakies Pretpaleis <[e-mail]>
wrote:

On Jul 31, 8:57 pm, "David W. Fenton" <[e-mail]>
wrote:

"Brian Graham" <[e-mail] innews:2f*************************@PRIMUS.CA:

Everytime after I change something in for example a module I close
Access. When I open it, Access crashes. My last change was a new
linked table, a query and a new form. When reopening, crash. Also
when I get the backup and import everything, this happens. Does
anyone have an idea what this is and how it is caused?

Corrupted compiled code. Decompile, compact, recompile and compact
and it will likely go away permanently.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Hello Brian,

Thanks for your reply. I have been searching in Access for this, but I
can't seem to find it. Where do I find the decompile option?

Thanks agian.
Sjakie.

I have found following in the help:

Renaming a Database

When you rename a database, compiled code in the database will be
decompiled. To recompile code and save all modules in a compiled
state, open the database, open a module in Design view, and click
Compile And Save All Modules on the Debug menu.

Is that it???

Thanks

[Sjakies Pretpaleis]

On Aug 1, 2:13 pm, Sjakies Pretpaleis <[e-mail]>
wrote:

On Jul 31, 8:57 pm, "David W. Fenton" <[e-mail]>
wrote:

"Brian Graham" <[e-mail] innews:2f*************************@PRIMUS.CA:

Everytime after I change something in for example a module I close
Access. When I open it, Access crashes. My last change was a new
linked table, a query and a new form. When reopening, crash. Also
when I get the backup and import everything, this happens. Does
anyone have an idea what this is and how it is caused?

Corrupted compiled code. Decompile, compact, recompile and compact
and it will likely go away permanently.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Hello Brian,

Thanks for your reply. I have been searching in Access for this, but I
can't seem to find it. Where do I find the decompile option?

Thanks agian.
Sjakie.

That should be David, not Brian. Sorry!!!

[Jens Schilling]

Hi,

>Corrupted compiled code. Decompile, compact, recompile and compact
and it will likely go away permanently.

Thanks for your reply. I have been searching in Access for this, but I
can't seem to find it. Where do I find the decompile option?

It's a switch to start Access; the usual way is to create a shortcut on your
desktop to the Access-Exe and edit the target properties like this :

"C:\PathToMSAccess\MSACCESS.EXE" /decompile "C:\PathToDatabase\DBName.mdb"

Regards
Jens

[David W. Fenton]

maxhugen <devdex_AT_hugen_DOT_com_DOT_auwrote in
news:46**********************@news.qwest.net:

A decompile, followed by a re-compile, then a compact has always
fixed the issue.

I also compact between the decompile and recompile.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Sjakies Pretpaleis]

Thanks everyone. These links helped me very much. My database went
from 6mb to 2mb. This is great!!!