Solved

Visual Basic editor crashes in MS ACCESS 2000

Posted on 2004-09-20
11
275 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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

737 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