Access 2000 to 97 Conversion

[Randy Bean]

I built a library database for a client in 2000, it uses
several check boxes and compb boxes to perform filtering
and works well in 2000. In the 97 it does not first it
does not like a method I use called application.name and
then it does not like the Replace statement I use in my
SQL. Everything else works well. The only difference I
find in the two is basicall the Microsoft 8.0 objects in
the 97 version and the Microsoft 9.0 objects in the 2000.
Hen I try to change the 97 version to the 9.0 I am told
there is a name conflict and will not permit the selection
and when I try to deselect the 8.0 to get the 9.0 it will
not allow the deletion becasue it is required for the
database. Do you have any suggestions on how to drop the
8.0 and get to the 9.0?

I appreciate you assistance and insight

Regards
RC Bean

 

[John Nurick]

Hi Randy,

Access 2000 is version 9.0 and Access 97 is version 8.0, so what you're
trying is impossible.

You'll need to do the following, more or less:

- write your own Replace() function in a VBA module (there's no standard
Replace() function in Access 97).

- compile all modules to find other problems with the VBA. Some of these
may relate to missing or incorrect references (see below), others to
constants, functions, etc. that exist in Access 2000 but not in the
earlier version.

- make the necessary adjustments and re-compile until everything works.


Here - courtesy of Douglas J. Steele MVP
- is how to check and repair your references:

Open any code module (or open the Immediate Window,
using Ctrl-G, provided you haven't selected the "keep
debug window on top" option). Select Tools |
References from the menu bar. Examine all of the selected
references.

If any of the selected references have "MISSING:" in
front of them, unselect them, and back out of the dialog.
If you really need the reference(s) you just unselected
(you can tell by doing a Compile All Modules), go back
in and reselect them.

If none have "MISSING:", select an additional reference
at random, back out of the dialog, then go back in and
unselect the reference you just added. If that doesn't
solve the problem, try to unselect as many of the
selected references as you can (Access may not let you
unselect them all), back out of the dialog, then go back
in and reselect the references you just unselected.
(NOTE: write down what the references are before you
delete them, because they'll be in a different order
when you go back in).

Just so you know: the problem will occur even if the
library that contains the specific function that's
failing doesn't have a problem.

For more information see http://www.mvps.org/access/bugs/bugs0001.htm

I built a library database for a client in 2000, it uses
several check boxes and compb boxes to perform filtering
and works well in 2000. In the 97 it does not first it
does not like a method I use called application.name and
then it does not like the Replace statement I use in my
SQL. Everything else works well. The only difference I
find in the two is basicall the Microsoft 8.0 objects in
the 97 version and the Microsoft 9.0 objects in the 2000.
Hen I try to change the 97 version to the 9.0 I am told
there is a name conflict and will not permit the selection
and when I try to deselect the 8.0 to get the 9.0 it will
not allow the deletion becasue it is required for the
database. Do you have any suggestions on how to drop the
8.0 and get to the 9.0?

I appreciate you assistance and insight

Regards
RC Bean

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.