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

Tech-Archive recommends: Speed Up your PC by fixing your registry

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

.

Quantcast