2007 constantly crashing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 29 Dec 2007 01:38 GMT

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

Reply to this Message

Arvin Meyer [MVP] - 29 Dec 2007 04:22 GMT

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.
[quoted text clipped - 5 lines]
>
> 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.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Reply to this Message

Steve - 29 Dec 2007 05:22 GMT

> inline:
>
[quoted text clipped - 23 lines]
> --
> Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com

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

Reply to this Message

Arvin Meyer [MVP] - 29 Dec 2007 17:58 GMT

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)

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

On Dec 29, 3:22 pm, "Arvin Meyer [MVP]" <a...@m.com> wrote:

> inline:
>
[quoted text clipped - 28 lines]
> Arvin Meyer, MCP,
> MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com

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

Reply to this Message

Tony Toews [MVP] - 30 Dec 2007 20:39 GMT

>> 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

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

Tony

Signature

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/

Reply to this Message

Baz - 29 Dec 2007 05:53 GMT

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.

>I have an XP machine (all updates installed) with both Office 2003 and
> Office 2007 installed. 2003 was installed first and has been running
[quoted text clipped - 15 lines]
> TIA
> Steve

Reply to this Message

Steve - 29 Dec 2007 22:16 GMT

> 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
[quoted text clipped - 30 lines]
>
> - Show quoted text -

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

Reply to this Message

Tony Toews [MVP] - 30 Dec 2007 23:31 GMT

>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

Signature

Reply to this Message

Baz - 31 Dec 2007 08:57 GMT

>>n.b. the only thing I have found so far that guarantees to crash Access
>>2007
[quoted text clipped - 7 lines]
>
> Thanks, Tony

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.

Reply to this Message

Tony Toews [MVP] - 30 Dec 2007 20:46 GMT

>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

Signature

Reply to this Message

Arvin Meyer [MVP] - 31 Dec 2007 03:47 GMT

> 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.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Reply to this Message

Baz - 31 Dec 2007 08:54 GMT

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

>>More importantly, I am getting constant crashes in 2007 (Access only,
>>other Office apps seem fine) to the point where it is unworkable.
[quoted text clipped - 10 lines]
>
> Tony

Reply to this Message

Tony Toews [MVP] - 31 Dec 2007 19:00 GMT

>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

Signature

Reply to this Message