error when opening vba editor

[HGood]

Hi, just today I've run into a problem, when I press Alt+F11 to open the VBA
editor, I get an error message that Access has encountered a problem, do I
want to tell Microsoft. Seems I had this problem a few times over the past
week, but today I can't get editor to open at all after repeated attempts.

Some previous versions of the database have the same problem, but some older
ones in another folder don't. So it doesn't affect all my databases. If I
open Northwind, it's no problem.

I saw some previous discussions about this, but no one had a solution.
Someone suggested opening a new database and copying everything over. I
haven't found a way to do that other than one form, query, and report at a
time. That'd be well over 100 drag and drops. : (

Any advice would be appreciated. Harold

 

[John Spencer]

Open the new database
Select File: Get External Data: Import from the menu
Navigate to your old database.
Select all the items you want to import
Don't forget to press the options buttom and make the appropriate selections
there.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[HGood]

Fantastic, it worked like you said and appears to have solved that problem!
Thanks for such a quick reply.
Harold