Alt-F11 crashes database

[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

 

[Allen Browne]

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.

 

[Humphrey]

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.

 

[David W. Fenton]

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.

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.

 

[Humphrey]

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.

 

[AccessVandal via AccessMonster.com]

My question might not be relevant.

When you created a new database, in the Access Options – Popular – Creating
databases – Default file format, is the format set to Access 2007 or 2002-
2003 or 2000?

If the new database is created using older format, you may have problems
importing objects into 2007 format but you would not have problems importing
older formats into 2007 format. (Same as for 2000 and 2002-2003.) 2007 wizard
is not so smart to warn you if you make a mistake by renaming the file name
and the file extension in the text field. You have to select the browser and
in the file menu, select the combo box for the correct format, not just by
changing the file extension.

It will prompt a message if you attempt to import 2007 objects into older
versions. Did a message appear?

 

[Humphrey]

From 2007 to 2007. I need that for the SharePoint functionality

 

[David W. Fenton]

No, he did a Save As on the entire database; saving it as a new
file.

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.

That is not SAVE AS -- that's TOOLS -> DATABASE UTILITIES -> CONVERT
DATABASE.

 

[Humphrey]

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

 

[Allen Browne]

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.

 

[AccessVandal via AccessMonster.com]

You are right about the Office button. (I was refering to Access Options not
Save As)

If the default format is 2007 (creating a new database), as long as you had
never edited the file extension, you're safe from error.

I don’t have any suggestion to offer, but just to suggest other options.
Could these be a multi-core processor problem or due to insufficient RAM?

It’s a good idea to do a thorough trial test before deploying. Testing seems
to resolved some problems but some will remain.

But than again, 2007 seems to have many unresolved bugs. According to MSDN,
Excel is multi-threaded but not Access 2007. I hope that’s not one of those
problems.

 

[David W. Fenton]

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

I missed the A2007 part of this somewhere along the line.