Alt-F11 crashes database

  • Thread starter Thread starter Humphrey
  • Start date Start date
H

Humphrey

I have a 2007 database that has decided to crash whenever i try entering the
VBA environment either to run or edit it. This has come about from nothing
but prevents the database from running, or me making any corrections to
remedy it.
I've tried importing into a new DB but the offending forms will not import
and trying a save as into a new DB won't work since Access tells me that the
file is already in use (it is - but only by me trying to do a save as).
As usual this is a critical DB and the backups are painfully out of date so
i would appreciate any ideas on how to correct this one.

H
 
If this happens in a particluar database only, try a compact, decompile,
compact sequence. Details of these recovery steps:
http://allenbrowne.com/recover.html

If it happens in all databases but only started recently, have you installed
other software recently?

You may be able to import all but 1 or 2 bad forms into a new database. It
would then be possible to import the bad form(s) from a backup, so your data
is completely up to date and you may not have to redesign those forms from
scratch.
 
Thanks for the response. To keep everyone in the loop I was able to get it
fixed by sending the offending database to a colleague who opened it and did
a Save As to a new filename. He then sent the DB back to me.
Strangely all has worked correctly since then.

I'm not advocating this in lieu of Allen's process below, but as a wise man
once said "If it's stupid and it works; it's not stupid". Thanks for your
help.
 
To keep everyone in the loop I was able to get it
fixed by sending the offending database to a colleague who opened
it and did a Save As to a new filename. He then sent the DB back
to me. Strangely all has worked correctly since then.
Click to expand...

My copy of Access has a Save As menu item but it only allows me to
save a selected object under a different name.

I suspect your friend created a new file and imported the contents
of your problematic file, which is part of what Allen had suggested
you try.
 
No, he did a Save As on the entire database; saving it as a new file. He's
not very au fait on the workings of Access so i talked him through the
process over the phone. When you choose Save As one of the options is to
save the database as a new 2007 DB, or a 2003 DB, etc. We simple chose 2007,
gave it a new name and returned it back to me.
 
No, he did a Save As on the entire database; saving it as a new
file.
Click to expand...

No, he didn't. There is no such functionality in Access, nor has
there ever been.
He's
not very au fait on the workings of Access so i talked him through
the process over the phone. When you choose Save As one of the
options is to save the database as a new 2007 DB, or a 2003 DB,
etc. We simple chose 2007, gave it a new name and returned it
back to me.
Click to expand...

That is not SAVE AS -- that's TOOLS -> DATABASE UTILITIES -> CONVERT
DATABASE.
 
I don't know how else to say it but you are WRONG. I'm looking at the screen
now. Click on the Office icon (or whatever its called top left of the
screen) choose Save As, and you are presented with five options.

Save The Current Database Object
* Save Object As
* Find Add-Ins for other file formats

Save The Database in Another Format
* Access 2007 Database
* Access 2002-2003 Database
* Access 2000 Database

I don't know how i can be more explicit than that. I know what I did; I was
there. I've been doing this stuff for a lot of years and certainly know how
to find my way around the software. Please get a copy of Access 2007 and
check it out for yourself. Do you want me to send you screen shots directly
or are you finally convinced?

H
 
I believe this is new to Access 2007.

David is very knowledgeable about previous versions, but I'm not sure he's
an A2007 user.
 
Back
Top