VBA Problem in Access 2003

[Paul Gulliver]

Until recently everything was fine, now when I open a database in Access
2003 I get a window stating 'installing a Microsoft Office Access feature'.
When this has installed the switchboard form works OK but the buttons on
other forms which are used to open and close additional forms don't work and
produce an error message 'the expression on click you entered as the event
property setting produced the following error: error in loading dll'.

In the help section it refers to knowledge base 283806 I followed this but
no help.

As a test I tried designing a new form with buttons but the button wizard
refused to operate correctly.

I have tried repairing Office and also removing and re-installing it but the
problem still exists.
The problems seem to have occurred after installing AutoCAD 2005 which I
have now removed
I'm running Windows2k with sp4

Paul

 

[Tom Wickerath]

Hi Paul,

AutoCAD 2005 may have messed up your MDAC files. Here is a KB article written for Access 2002,
which likely applies to Access 2003 as well:

"Error in loading DLL" error message when you run a Microsoft Access wizard in Access 2002
http://support.microsoft.com/?id=833220

Tom
________________________________________


Until recently everything was fine, now when I open a database in Access
2003 I get a window stating 'installing a Microsoft Office Access feature'.
When this has installed the switchboard form works OK but the buttons on
other forms which are used to open and close additional forms don't work and
produce an error message 'the expression on click you entered as the event
property setting produced the following error: error in loading dll'.

In the help section it refers to knowledge base 283806 I followed this but
no help.

As a test I tried designing a new form with buttons but the button wizard
refused to operate correctly.

I have tried repairing Office and also removing and re-installing it but the
problem still exists.
The problems seem to have occurred after installing AutoCAD 2005 which I
have now removed
I'm running Windows2k with sp4

Paul

 

[Paul Gulliver]

Tom,
Thanks for your reply - I've just tried the suggestions in 833220 but
unfortunately they don't make any difference.
I think the problem may lie in the VBA files.

Paul

 

[Arvin Meyer]

My guess is that the VBA6.dll was replaced by autocad with a later version,
and since it is a shared dll, it is not removed when you
uninstall/reinstall. Try removing it manually after completely uninstalling
Office. Then reinstall Office.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Paul Gulliver]

I've done a search of program files and the Win2k directory but I can't find
the VBA6.dll, I found VBA6 sub-directory (under Microsoft shared) and it has
files like VBACV10.dll, VBACV20.dll, VBE6.dll. - Would it be safe to remove
the whole directory? or am I looking in the wrong place.

Paul

 

[Arvin Meyer]

First look in the registry to make sure that there are no other vital
programs using aning of thos dlls:

Start ... Run

then type

regedit.exe

Do a search under each of the dlls. If AutoCad has been uninstalled, remove
those registry keys if you find any. Also remove the keys to your Office
install.

IMPORTANT: MAKE SURE TO BACKUP THE REGISTRY BEFORE YOU START.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access