Database Crashes when opening table or query in design view

[Mark A. Sam]

Hello,

I am using A2007 and having a problem of the dabase crashing whenever I open
a query or form. It started out as occasional and now if consistent. A
Microsoft Office diagnosis tool came up and I ran it. It told me I had a
problem that it couldn't fix.

Does anyone know how to fix this problem?

Thank you and God Bless,

Mark A. Sam

 

[Allen Browne]

Hi Mark

This is the standard routine I usually run to rescue a crashing database:

1. Uncheck the boxes under:
Office Button | Access Options | Current Database | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Office Button | Manage | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code),
and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

7. Still in the code window, choose Options on the Tools menu. On the
General tab, make sure Error Trapping is set to:
Break on Unhandled Errors
and the Compile on Demand is unchecked.

At this point, you should have a database where the name-autocorrect errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, reference ambiguities are resolved,
the code syntax is compilable, and the VBA options are set to show errors
and avoid this kind of corruption.

If it is still a problem, the next step would be to get Access to rebuild
the database for you. Follow the steps for the first symptom in this
article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html

 

[Mark A. Sam]

Hello Allen,

I tried all of this and am still crashing. If I don't get any other
suggestions soon, I'm just going to uninstall and reinstall Office 2007. I
was hoping to avoid that.

Thanks for you help and God Bless,

Mark

 

[Allen Browne]

Is it a particular query? A particular form?

Post the SQL statement for the query if you can.

You might try the undocumented SaveAsText if it's a particular form. Then
delete it, compact, and LoadFromText.

There are some bugs in A2007, but we need something specific to put our
finger on here.

 

[Mark A. Sam]

It's opening any query and any table in design view. Even a new query or
new table, if I open either then close, the db crashes. I created a new db
and a new table, and it crashed. .

 

[Allen Browne]

That's different to my experience, Mark.

Might be worth a complete uninstall, and reinstall.

 

[Mark A. Sam]

That is what I am doing right now. I'll let you know how it works. For
your info, and for reference, there was an option on the change/uninstall on
the Add/Remove software to repair Office 2007. That didn't work for me, but
it may for someone else.

 

[Mark A. Sam]

Uninstall and Reinstall didn't help. I believe there si some kind of issue
with addressing tables, which would by the reason for queries causing the
crashes as well as tables. I am using the trial version, but don't know if
that could be a factor. I guess I'll keep plugging away at it.

 

[Mark A. Sam]

When I reinstalled Office 2007, I decided to install Outlook 2007, becuase I
wanted to try out the email form functionality at some point. Outlook 2007
blew away my previous version without notice. That surprised me and is
irritating, becuase the interface is different and I don't know if I even
want to purchase Office 2007. I just wanted to caution anyone in case they
want to keep their current version of Outlook.

 

[Rick Brandt]

When I reinstalled Office 2007, I decided to install Outlook 2007,
becuase I wanted to try out the email form functionality at some
point. Outlook 2007 blew away my previous version without notice. That
surprised me and is irritating, becuase the interface is
different and I don't know if I even want to purchase Office 2007. I
just wanted to caution anyone in case they want to keep their current
version of Outlook.

Correct. Unlike all the other Office applications you can only have one
version of Outlook installed on a system. There is not going abck and forth
allowed.

 

[Mark A. Sam]

Hi Rick,

So I don't buy Office 2007, I am done? That doesn't make sense. If you
can't have multiple versions, I think they should have given a warning.

Thanks for the help

God Bless,

Mark

 

[Allen Browne]

You can have multiple versions of Access.
You cannot have multiple versions of Outlook.

IMHO, A2007 is a learn-only exercise until MS releases the service pack.
There's just too many things that don't work properly at this stage.

I don't know what might be causing your issue, Mark. Clearly something's
gone wrong that I have not experienced.

 

[Mark A. Sam]

Hello Allen,

According to Rick, if I understand him correctly, I cannot move back to
Outlook 2002. I only wanted to try out a feature. Microsoft put this
statement on its download website: "Try out your choice of suites or
programs from the 2007 Microsoft Office release for 60 days! Trial programs
contain the same functionality that you get when you buy the perpetual
versions-but only for a limited time. " That suggests that it isn't a
learning exercise, but the working version with a time limit.

Thank you for your time and help Allen. I'm going to develop my app in
A2002. All I really need from A2007 is the ability to send .pdf reports as
attachments.

God Bless,

Mark

 

[Allen Browne]

Rick may have tried something I haven't. When I installed Office 2007, I did
a custom install, allowing it to remove my previous version of Outlook (but
not Access.) I choose to stay with the same old file format for Outlook
(pst.) Therefore if I uninstalled Office 2007 completely, I would expect to
be able to install Office 2003 again, and have Outook 2003 use the file.

That's not from experience, but it's what I would expect.

 

[Rick Brandt]

Hello Allen,

According to Rick, if I understand him correctly, I cannot move back
to Outlook 2002. [snip]

I meant you cannot have them both installed at the same time and go back and
forth like you can with Word, Access and Exel. You certainly can uninstall
Outlook 2007 and then reinstall the older version.

 

[Mark A. Sam]

Sorry, I did misunderstand.

Hello Allen,

According to Rick, if I understand him correctly, I cannot move back
to Outlook 2002. [snip]

I meant you cannot have them both installed at the same time and go back
and forth like you can with Word, Access and Exel. You certainly can
uninstall Outlook 2007 and then reinstall the older version.