2000 to 2003

S

scottm

We have recently upgraded from 2000 to 2003. My macros do not apear to be
working. I get a message that active X needs to be registered. What do I need
to do to get functionality back
 
S

scottm

Allen thanks for your reply.
The ADO library is checked. Also I am getting a warning that there may
be bad code. This db was orignally done in 97 updated in 2000 with no issues.
The macros are critical to the function of the db. I appreciate any input.
 
A

Allen Browne

Are there any references marked with the word "MISSING"?

If the code does not compile, it can interfere with your macros. In the VBA
window, choose Compile from the Debug menu. Fix any errors, and repeat until
it does compile. (This assumes you've already sorted out any references
problem.)
 
S

scottm

There are no references marked missing. I have compiled code. It seems to be
isolated to an unbound form used to set the date range in queries. It is one
form that is used quite frequently on several different queries. The queries
apear to function if I don't use the date form. I built this form way back in
the begining using the instructions in the help file.
 
A

Allen Browne

This old form may be damaged.

Try following the steps here, in order:
Recovery sequence - Standard steps to recover a database
at:
http://allenbrowne.com/recover.html
Since the problem involves a change in version, the decompile part may do
the trick, but the other steps are important too.

Not related to your specific problem, but you might want to make sure you
have this hotfix for Access 2003 if you have Service Pack 3:
http://allenbrowne.com/bug-Access2003SP3.html
 
Top