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

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





On Thu, 24 Jul 2003 14:04:50 -0700, "Randy Bean" <rbean@fdecorp.com>
wrote:

>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.