Access (all of Office!) freezes on opening VBA editor

[John Vinson]

Well, I'm coming for help instead of with help this time...

Monday for no apparent reason Access started freezing - just ceasing
to respond, bringing up "the application is not responding" when I try
to exit with the X - whenever and however I try to open the VBA
editor. I later found that all Office apps and all databases I tested
do the same: Excel, Word, PowerPoint. I can use the database normally,
just not edit code.

I've opened a Microsoft incident (and a very helpful young lady named
Scotland is working on it for me), but I wondered if any of the
accumulated wisdom of the newsgroup has seen this problem or has any
suggestions.

Details:
- AccessXP/OfficeXP
- WindowsXP Pro
- All current patches/updates applied (which might be the problem!)
- Uninstalling Office, removing Office keys from the registry,
reinstalling Office: no change in behavior
- Visual Studio .NET was installed a few months ago; removing it had
no effect

 

[gandalf]

Tried to delete all temporary files?

in the windowsdir\temp
document & settings\user\local settings\temp

I had word 97/2000 crashing when opening a file before I
cleaned the temp files.

 

[Dev Ashish]

I later found that all Office apps and all databases I tested
do the same: Excel, Word, PowerPoint. I can use the database normally,
just not edit code.

Are there any entries in Event viewer regarding this? Did you try re-
registering C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6
\vbe6.dll; and/or renaming VBA6 folder and then repairing Office?

-- Dev

 

[John Vinson]

Tried to delete all temporary files?

in the windowsdir\temp
document & settings\user\local settings\temp

I had word 97/2000 crashing when opening a file before I
cleaned the temp files.

From a wysard to a wizard, thanks for the suggestion; yep, my temp
files are groaningly full. I'll give it a try.

 

[John Vinson]

Are there any entries in Event viewer regarding this? Did you try re-
registering C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6
\vbe6.dll; and/or renaming VBA6 folder and then repairing Office?

-- Dev

Thanks Dev - I'm running this by the MS Support person but it sounds
like a good idea. vbe6.dll is certainly turning up in the event logs.

 

[TC]

Probably a silly question but: is it all Office apps, or all *big* apps? Ie.
are there other big (non-Office) apps that work ok?

TC

 

[TC]

I wasn't necessarily thinking of VBA apps. I just wondered if it was some
kind of resource problem

TC

 

[John Vinson]

Probably a silly question but: is it all Office apps, or all *big* apps? Ie.
are there other big (non-Office) apps that work ok?

Well, I don't know of any other apps that have Visual Basic for
Applications as part of them - can you suggest any to try?

FWIW I've decided to wipe my hard disk clean and reinstall everything.
There are enough other wierd things going on that I really suspect my
registry is fouled up bigtime.