Buttons on forms do not respond on target PC

[Jake]

Hello,
I'm having a problem deploying my Access database on
some target PCs. The buttons on the forms will not
respond. I created the Access database in Access 2002 on
a Windows XP machine. While some PCs running Windows
2000 and Access 2002 do not have this problem, others
do. Does anyone know what is going on?

Thanks.

 

[Van T. Dinh]

If you have things that work in some Access installation but not in some
others, the most likely cause is the Reference Errors on the problematic
PCs.

See Douglas J. Steele's article:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[Jake]

Thanks for your response. I placed code to display
each of the references and whether they are broken or
not. The code for the references is the first code
executed. I ran the code on the problem target PC and
each reference is found and is not broken.
The references that my Access database utilize are
VBE6.DLL, MSACC.OLB, STDOLE2.TLB, SCRRUN.DLL, DAO360.DLL,
MSCOMCTL.OCX, and EXCEL.EXE. Is there something I need
to know about any of these references?
I looked through the document in your response, but I
haven't found the answer to this issue. Is there
anything else I can check into either with the references
or some where else in Access?

Thanks.

 

[Van T. Dinh]

I tend to avoid the MSCOMCTL.OCX as this often gives errors and weird
behaviours. Instead, I use the code from The Access Web:

http://www.mvps.org/access/api/api0001.htm
http://www.mvps.org/access/api/api0002.htm

Also, the Reference EXCEL.EXE is different from what I normally use. To
automate Excel, I use the Reference Excel{VersionNo}.OLB (Object Library)
rather than the EXE.

Sometimes, you do get corruptions in the References and even though none is
marked as "MISSING", you still get strange behaviours in your database. One
of the procedure to fix this is to select an additional Reference, OK to get
out, get back in, unselect the selected Reference, the OK again. Since the
References got to be updated, the update quite often gets rid of the
corruptions. This is detailed in Douglas J. Steele's article.

Note: you need to do this *on the problem PCs*.