Visual Basic editor crashes in MS ACCESS 2000

Ive have an issue with the visual basic editor crashing MS ACCESS 2000 when I try to type into it.  It lets me type about 3 words then it bombs out "msaccess.exe has encountered an error and has to close".
This is the error signature:
AppName: msaccess.exe       AppVer: 9.0.0.2719       ModName: vbe6.dll
ModVer: 6.0.84.35       Offset: 000ad365

This is not database specific, happens on all of them, and only on this computer.  Other computers can edit the same databases in vb with no problem.  

I have reinstalled access (office) completely, tried the REPAIR option, and uninstalled and reinstalled.  Nothing works.

The workstation is XP Pro SP1.  I havent had any issues like this until about 2 weeks ago.  It seems to have started out of the blue.  I do not recall changing any office related settings.

Can anyone shed some light on this problem?
LVL 1
Col_BeckwithAsked:
Who is Participating?
 
shanesuebsahakarnCommented:
Ah hang on - it just doesn't run on WinXP. The only thing I can suggest is to uninstall Office, search for the vbe6.dll and unregister and delete it. I don't know what effects that might have on your VB installation though.
0
 
shanesuebsahakarnCommented:
Have you installed the latest Office service packs?
0
 
Data-ManCOOCommented:
are there any applications on this machine that aren't on the rest?  Sounds like a dll conflict.

Mike
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Col_BeckwithAuthor Commented:
The computers all use the same software and apps.  The unit has all service packs and updates for Xp Sp1 and Office 2000 installed.
0
 
shanesuebsahakarnCommented:
That version of vbe6.dll isn't the latest version for A2K. Which service packs do you have installed for Office?
0
 
Col_BeckwithAuthor Commented:
Sp3 for office and all the updates for it that came after it.

I also have Visual basic 6.0 Professional installed.
0
 
flavoCommented:
I had the same thing when i inslled MS Frontpage, i had to do a full reinstall.
0
 
Col_BeckwithAuthor Commented:
I did a full reinstall of everything.
0
 
shanesuebsahakarnCommented:
You may need to use Eraser2K to completely uninstall Office 2000:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;239938
0
 
Col_BeckwithAuthor Commented:
That program looks a bit flakey, it had some specifics about not being tested with Windows XP - have you used it on an XP system?  Im not sure I should.
0
 
Col_BeckwithAuthor Commented:
Problem solved!!

Shanesuebsahakarm - I did what you suggested and  unregistered and reinstalled vbe6.dll, problem still occurred.  No dice.

After some messing around with access, there vb dll error I was getting was in a database I modified from the northwind that comes with access.  I wanted to go back and look at some of the code in one of the controls and compare it with what I had.  When I tried to create a new database from the wizard, I got another error "ActiveX Component Can't Create Object".  I thought somehow this was probably related to the dll error I was getting so I googled the 'object' error and got this page.  I was able to fix the dll problem and the object error by reregistering ms DAO, that fixed it.  I found a page on the MS website that addressed the issue.  What you suggested kind of led me there so I guess the points should be yours.

Here is the page if you are interested:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;319841

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.