Solved

Visual Basic editor crashes in MS ACCESS 2000

Posted on 2004-09-20
11
276 Views
Last Modified: 2013-11-25
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?
0
Comment
Question by:Col_Beckwith
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
11 Comments
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12106090
Have you installed the latest Office service packs?
0
 
LVL 18

Expert Comment

by:Data-Man
ID: 12106120
are there any applications on this machine that aren't on the rest?  Sounds like a dll conflict.

Mike
0
 
LVL 1

Author Comment

by:Col_Beckwith
ID: 12106350
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12106415
That version of vbe6.dll isn't the latest version for A2K. Which service packs do you have installed for Office?
0
 
LVL 1

Author Comment

by:Col_Beckwith
ID: 12106464
Sp3 for office and all the updates for it that came after it.

I also have Visual basic 6.0 Professional installed.
0
 
LVL 34

Expert Comment

by:flavo
ID: 12106472
I had the same thing when i inslled MS Frontpage, i had to do a full reinstall.
0
 
LVL 1

Author Comment

by:Col_Beckwith
ID: 12106484
I did a full reinstall of everything.
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12106502
You may need to use Eraser2K to completely uninstall Office 2000:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;239938
0
 
LVL 1

Author Comment

by:Col_Beckwith
ID: 12106593
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
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 125 total points
ID: 12106612
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
 
LVL 1

Author Comment

by:Col_Beckwith
ID: 12113145
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question