Re: Database Crashes when opening table or query in design view

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.



"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
news:%23Ka$$wlEIHA.2268@xxxxxxxxxxxxxxxxxxxxxxx
That's different to my experience, Mark.

Might be worth a complete uninstall, and reinstall.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mark A. Sam" <NotTelling@xxxxxxxxxxxxxxxxx> wrote in message
news:OfgG4nkEIHA.5044@xxxxxxxxxxxxxxxxxxxxxxx
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" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
news:eyyGObkEIHA.2004@xxxxxxxxxxxxxxxxxxxxxxx
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" <NotTelling@xxxxxxxxxxxxxxxxx> wrote in message
news:%23l6GAVkEIHA.3980@xxxxxxxxxxxxxxxxxxxxxxx
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" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
news:uMcSkEkEIHA.4476@xxxxxxxxxxxxxxxxxxxxxxx
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" <NotTelling@xxxxxxxxxxxxxxxxx> wrote in message
news:eiUFRCkEIHA.280@xxxxxxxxxxxxxxxxxxxxxxx
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



.

Loading