Access Shuts Down

[Connie]

Hello all,

My database shuts down if I try to do anything in the Properties of a combo
box or text box.

Does anyone know why this would happen? Any fixes?

Any help appreciated.

Connie

 

[Tom Wickerath]

Hi Connie,

Try opening your database with the undocumented /decompile switch, then
immediately do a compact and repair. If you have just one version of Access
installed on your PC, then click on Start > Run and enter:

msaccess /decompile

Navigate to your database. Hold down the Shift key to prevent any startup
forms from opening (which may attempt to run code as well). Now do a compact
and repair operation, again holding down the Shift key the entire time, until
your database re-opens. In Access 2003 and earlier, click on:

Tools | Database Utilities | Compact and repair database

In Access 2007, click on the Office button, then Manage, and then Compact
and repair.

Finally, after the compacted database re-opens, open any code module and do
a Debug | Compile {ProjectName}


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Connie]

Thank you Tom. I will attempt this right away. Only one version of Access

 

[Tom Wickerath]

You might have a corrupt form, which may or may not get fixed with the steps
I outlined in my previous reply. If you still experience the shutdown, try
creating a new form, and then copy all controls from each section of the
suspect form to the new form, setting various section properties the same
(backcolor, height, etc). Copy any VBA code from the suspect form, paste it
into a text editor (NotePad), save, and then copy from NotePad and paste into
a newly created class module for the new form.

I'll try to remember to monitor this thread for any followup tomorrow
morning. I'm calling it an evening now. Good Luck!

Recovery sequence
http://allenbrowne.com/recover.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Connie]

Hi Tom,

I tried your suggestion (tried twice just in case I missed something). It
still will not let me do anything in Properties.

I am remotely doing the fix. Will this prevent the fix from working?

Otherwise, is there anything else I can do?

Connie

 

[Connie]

Hi Tom,

Just refreshed and your below email was there. In response, here are some
details of the database. For one, it is split and the back end seems to have
the same problem. Access shuts down if I attempt to do anything in
properties. Would my version of Access itself be corrupt?

Connie

 

[Mr. B]

Connie,

If what Tom has suggested did not help, then I would suggest that you try
this:

Create a new database file and import just one form into the new database
from the old one and then test the new database file to see if you have the
same problem. If not, then go back and import the rest of your forms, etc.
into the new database file. If you still have the problem then you will need
to post back here to see if we can come up with any other options.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[Tom Wickerath]

Hi Connie,

Would my version of Access itself be corrupt?

What happens if you open the sample Northwind database, open a form in
design view, and attempt to view the properties for a control? Does Access
crash once again? If the answer is yes, then it would appear that something
is corrupt with your installed copy of Access. Have you tried running the
Detect and Repair procedure? Which version of Access, including service pack,
are you running?

From your follow-on message:

I am remotely doing the fix.

I do not recommend ever attempting to open an object in Access, in design
view, when there is a network that separates you from the file. There is
simply too much risk of corruption, which may occur due to a noise in the
network. Copy the file to your local hard drive before attempting to open an
object in design view. Do the changes locally, and then post the copy back to
its original location when finished.

Otherwise, is there anything else I can do?

We need to find out if you are having this issue when working on a file that
is on your actual hard drive. If yes, is it just this database, or is it any
database when you attempt to access the properties?

Mr. B provided a good suggestion to try importing one object into a new
database. You can try the recovery sequence that I provide in a Word document
that I call "Access Links", that starts on the lower half of page 3 (look for
the section subtitled "My standard advice for attempting to fix minor
corruptions"). You are welcome to download a zipped copy from my web site.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[David W. Fenton]

Try opening your database with the undocumented /decompile switch

But make a backup copy before doing so!

 

[Tom Wickerath]

Hi David,

But make a backup copy before doing so!

I know that Michael Kaplan recommends doing this, in his article:

The real deal on the /Decompile switch
http://www.trigeminal.com/usenet/usenet004.asp?1033

However, in the literally hundreds of times that I have had to use this
undocumented feature, I have never had it "turn it into cottage cheese".
Besides, developers really should have fairly recent backups of their work at
all times in any case.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Tony Toews [MVP]]

However, in the literally hundreds of times that I have had to use this
undocumented feature, I have never had it "turn it into cottage cheese".
Besides, developers really should have fairly recent backups of their work at
all times in any case.

I had a problem once.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[David W. Fenton]

I know that Michael Kaplan recommends doing this, in his article:

The real deal on the /Decompile switch
http://www.trigeminal.com/usenet/usenet004.asp?1033

However, in the literally hundreds of times that I have had to use
this undocumented feature, I have never had it "turn it into
cottage cheese". Besides, developers really should have fairly
recent backups of their work at all times in any case.

I've had code lost from a decompile on the very rarest of occasions,
so I usually make a backup (though not always -- it depends on how
much work I've done since the last backup).