2007 constantly crashing

[Steve]

I have an XP machine (all updates installed) with both Office 2003 and
Office 2007 installed. 2003 was installed first and has been running
fine for years. I have two issues

Whenever I start 2003 (after 2007 has been used) and vice versa, I get
an installation process. Is this normal

More importantly, I am getting constant crashes in 2007 (Access only,
other Office apps seem fine) to the point where it is unworkable.
This happens if I am using an old 2003 database (2000 file format), a
db converted from 2003 to 2007 or a db created in 2007. The only
issue I had on install was an error where it could not install a font
but I could never find out which font and have followed all the net
solutions to try to fix that issue (which may be unrelated)

Any suggestions

TIA
Steve

 

[Arvin Meyer [MVP]]

inline:

I have an XP machine (all updates installed) with both Office 2003 and
Office 2007 installed. 2003 was installed first and has been running
fine for years. I have two issues

Whenever I start 2003 (after 2007 has been used) and vice versa, I get
an installation process. Is this normal

Yes. Unfortunately, the time is painfully long in since Access 2007. This
improves somewhat with the Service Pack 1.

More importantly, I am getting constant crashes in 2007 (Access only,
other Office apps seem fine) to the point where it is unworkable.
This happens if I am using an old 2003 database (2000 file format), a
db converted from 2003 to 2007 or a db created in 2007. The only
issue I had on install was an error where it could not install a font
but I could never find out which font and have followed all the net
solutions to try to fix that issue (which may be unrelated)

Any suggestions

Try installing SP1 for Office 2007. Before you do, read over all the
documentation and track down any caveats found on Google. The Service Pack
may improve your problem, but it may create others.

 

[Steve]

inline:





Yes. Unfortunately, the time is painfully long in since Access 2007. This
improves somewhat with the Service Pack 1.



Try installing SP1 for Office 2007. Before you do, read over all the
documentation and track down any caveats found on Google. The Service Pack
may improve your problem, but it may create others.

Thanks for the suggestion but (and I apologise for not mentioning
this), in desperation I did this last week

 

[Baz]

I'm currently using 2007 on my (XP Pro) development machine which has every
version installed right back to Access 2, and I'm not finding it any more
unreliable than 2003 (although the reinstallation when switching versions is
a royal PITA). However, I am using it with SQL Server linked tables, which
may make what I am doing quite different to your setup. Is there any
pattern to this i.e. does it always crash when you are doing a particular
thing?

n.b. the only thing I have found so far that guarantees to crash Access 2007
is to attempt to change a text box to a label (or it might be the other way
around, I forget). The workaround is to delete the control and create a new
one, instead of trying to change it in situ.

 

[Arvin Meyer [MVP]]

Try the following in order:

1. Re-register DAO:

Start >>> Run then type:

regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll"

You should get a message the the registration succeeded.

2. Uninstall Office 2007 then reboot, run a registry cleaner, reboot again,
then reinstall Office 2007 and the Service Pack (if necessary)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

inline:





Yes. Unfortunately, the time is painfully long in since Access 2007. This
improves somewhat with the Service Pack 1.



Try installing SP1 for Office 2007. Before you do, read over all the
documentation and track down any caveats found on Google. The Service Pack
may improve your problem, but it may create others.

Thanks for the suggestion but (and I apologise for not mentioning
this), in desperation I did this last week

 

[Steve]

I'm currently using 2007 on my (XP Pro) development machine which has every
version installed right back to Access 2, and I'm not finding it any more
unreliable than 2003 (although the reinstallation when switching versions is
a royal PITA).  However, I am using it with SQL Server linked tables, which
may make what I am doing quite different to your setup.  Is there any
pattern to this i.e. does it always crash when you are doing a particular
thing?

n.b. the only thing I have found so far that guarantees to crash Access 2007
is to attempt to change a text box to a label (or it might be the other way
around, I forget).  The workaround is to delete the control and create anew
one, instead of trying to change it in situ.










- Show quoted text -

No - no pattern to the crashes that I can see, can be on simple things
or complex queries

 

[Tony Toews [MVP]]

Thanks for the suggestion but (and I apologise for not mentioning
this), in desperation I did this last week

A hotfix was just introduced for the problems which A2007 SP1
introduced. http://support.microsoft.com/kb/945674

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

More importantly, I am getting constant crashes in 2007 (Access only,
other Office apps seem fine) to the point where it is unworkable.

Try the hotfix. http://support.microsoft.com/kb/945674 It only
mentions a few specific scenarios where A2007 crashes but it might
just fix your problems.

As Arvin suggests then try uninstalling and reinstalling A2007.

However please send in your crash reports to Microsoft. While they
don't like getting them <smile> MS folks treat these as a very high
priority and do thier best to solve the underlying problems.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

n.b. the only thing I have found so far that guarantees to crash Access 2007
is to attempt to change a text box to a label (or it might be the other way
around, I forget). The workaround is to delete the control and create a new
one, instead of trying to change it in situ.

Reported to Microsoft.

Thanks, Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Arvin Meyer [MVP]]

However please send in your crash reports to Microsoft. While they
don't like getting them <smile> MS folks treat these as a very high
priority and do thier best to solve the underlying problems.

Many people don't like to bother with crash reports, but they must remember
the old adage:

The squeaky wheel gets the grease.

With software bugs, that's absolutely true. Microsoft can't fix what it
doesn't know about, nor will it spend very much time working on a problem
that only has a few complaints when there are others with lots of
complaints. Always send in a bug report unless the whole computer crash
makes that impossible.

 

[Baz]

That hotfix is for Access 2003 SP3. Is there a hotfix for Access 2007 SP1?
I can't find such a thing.

 

[Baz]

Reported to Microsoft.

Thanks, Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

I am currently working on a big project in Access 2007 (accdb with SQL
Server linked tables) and finding lots of issues. Most of the new features
are broken or flawed in one way or another. I will post a complete list
when I'm finished.

 

[Tony Toews [MVP]]

That hotfix is for Access 2003 SP3.

Arrgghhh. Sorry about that.

Is there a hotfix for Access 2007 SP1?
I can't find such a thing.

Not to my knowledge.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/