Clicking button fails

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have installed Microsoft Office 2003 on a new computer. When I tried to run
some already-working databases, they failed to run. When I clicked a button
in a form, MS Access says an error that it faild communication to OLE server
or ActiveX object. Or if I create a new form and a button and try to
associate a VB function to the button, MS Access says that it cannot open VB
module. What might be the problem?
Thank you.
 
Hi, Viktor.
I have installed Microsoft Office 2003 on a new computer. When I tried to run
some already-working databases, they failed to run.
Click to expand...

Most likely your database application has missing references. Open the
database application in Access 2003. Open any module and select the Debug ->
Compile <DatabaseName> menu. If a line of code is highlighted with an error
message such as "Unrecognized user-defined function" and you can tell it's a
built-in function, then you have a missing reference. For instructions on
how to fix this, please see the tip, "ADO and DAO Library References in
Access Databases" byTom Wickerath on this Web page:

http://www.Access.QBuilt.com/html/gem_tips1.html

Another cause is an ActiveX control on a form or report that is not
registered in the Windows Registry. If you can find any ActiveX controls in
your application, then find the path and file name of each control, verify
that you have exactly the same version of this control used in the
application as is found on your hard drive, and then register it in Windows.
Recompile the code, fix any errors and recompile again until there are no
more compilation errors.

To re-register the ActiveX control or DLL library, use the following syntax
from the Windows Start/Run command line, or DOS shell command line, or
Windows shortcut, or drag 'n drop file name onto Regsvr32.exe in Windows
Explorer, et cetera -- whatever your favorite method is for registering DLL's.

Regsvr32.EXE "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL"

Replace the path and file name with your control's or library's path and
file name.
Or if I create a new form and a button and try to
associate a VB function to the button, MS Access says that it cannot open VB
module.
Click to expand...

Ensure that you have the VBE6.DLL library installed and registered in
Windows. The default location is:

C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Hi,
(i)
I compiled code with no problem. No invalid function was found. So I have
all references
(ii)
I use no ActiveX controls in my database
(iii)
VBE6.DLL is registered with no problem.

As I have said before, the database was running with no problems on other
computers. It started to make problems with my new Office 2003 installation.
The problem must be in the MS Access itself. Even the MS Access example
databases do not work and cause the same error.

The hell knows where the problem is.

Thank you for your answer.
 
Hi, Viktor.
I compiled code with no problem. No invalid function was found. So I have
all references
Click to expand...

Unfortunately, that's not proof. Adding a new reference, compiling the
code, then removing this new reference, and then recompiling the code will
occasionally reveal a missing reference. Access 2000 has a bad habit of
this, but the more recent versions seem to rarely encounter this bug.
I use no ActiveX controls in my database
Click to expand...

Excellent! Far fewer headaches that way. This means that the error message
mentioning an ActiveX control or OLE server refers to an Access component,
not your database appliction.
The problem must be in the MS Access itself. Even the MS Access example
databases do not work and cause the same error.
Click to expand...

The ones that come with Access 2003? Or ones copied from a previous version
on another computer? If it's Access 2003 database examples not working, then
it sounds like either your user account doesn't have sufficient Windows
security permissions or you have a faulty installation of MS Office.

First, try logging in as the Windows Administrator and opening any of the
Access 2003 databases. If it runs with the Administrator account and not the
limited user account, then it's a Windows security permissions problem and
you need to have the
Windows Administrator assign sufficient permissions to your user account.

If the Windows Administrator receives the same errors as the limited user
account, then find the MS Office 2003 CD and attempt to repair Office while
still logged in as the Windows Administrator. If this doesn't fix the
problem, then uninstall and reinstall Office on this computer. Ensure that
you are logged in as the Windows Administrator during the reinstallation, and
that enough disk space is available (including the quota in the temporary
directories), and that a complete installation of the Access components is
conducted (no "Install on first use" allowed because you want no restrictions
while you are troubleshooting this problem).

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Back
Top