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
||7/24/2003 9:04:50 PM
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
- 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
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" <firstname.lastname@example.org>
>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
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
7/25/2003 5:54:23 AM
(page loaded in 0.053 seconds)
Access 97 to Access 2000 string functions - microsoft.public ...
I'm having problems converting my Access 97 programs to Access 2000. String functions such as right(), date(), and chr(13)&chr(10)used in queries won't convert.
Access 97 and Office 2000 - microsoft.public.access.conversion ...
I have a customized accounting program developed in Access 97. I cannot seem to upgrade it to Access 2000 successfully. I would therefore like to ...
Can't Convert Access 97 MDE File - microsoft.public.access ...
I have an application that we have been unable to get to work on Access 2000. I have created an MDE file and used office developer tools to create ...
Can't open my Access files after conversion from Access 97 to ...
Access 2000 File Format in Access 2003 - microsoft.public.access ... ... Can't open my Access files after conversion from Access 97 to ... I run Windows XP Pro SP 3.
read an Access 2000 table from an Access 97 application ...
I’ve read all about dragging files INTO Access ... You can open the 97 app in ... Access 2003 Application To Access 2007 ... open or convert an Access 97 or Access 2000 ...
Access 97 Switchboard coversion to Access 2002 - microsoft.public ...
Cannot open or convert an Access 97 or Access 2000 database in ... Cannot open or convert an Access 97 or Access 2000 database in Access 2002, in ...
Conversion from access 97 to 2002/ DAO 3.51 to 3.6 - microsoft ...
... to 2003 - microsoft.public.access ..... that VB6 code will have to reference dao 3.6. The data part will convert ... Cannot open or convert an Access 97 or Access 2000 ...
access 2000 converting text to number format - microsoft.public ...
... convert a text field to a number format so I can obtain a ... MS Development; MS Access; MS ACCESS 97 CONVERT TEXT TO NUMBER F… ... on 31,087 answers since March 2000 ...
Converting Access 95 to Access 2000-2003 - microsoft.public.access ...
You can convert a database that was created by using Microsoft Office Access 2003, Access 2002, Access 2000, or Access 97 to ... an Access 97 database, Convert an Access ...
convert MS Access databases 97 to 2003 - microsoft.public.access ...
MS Access: Automatically start up a form when database is opened ... In Access 2003/XP/2000/97, how ... or convert an Access 97 or Access 2000 database in Access ...
How to Convert an Access 2000 Database Back to Access 97 - Office ...
Upgrading to Access 2000 After you convert a database from a previous version of Microsoft Access to Access 2000, you might need to make a copy of the database ...
How To Convert an Access 2.0 Database to Access 97/2000
Wondering how to convert an Access 2.0 database to Access 97 or Access 2000? Follow these easy steps!
convert access 2000 mdb to 97: access 97, conversion
is there a way to convert an access 2000 mdb to access 97? ... This question has been solved and asker verified All Experts Exchange premium technology ...
Microsoft Access tips: Converting from Access 97
Access 2000, 2002, and 2003 let you convert a database back to Access 97 format, through: Tools | Database Utilities | Convert Database | To Access 97 File Format.
Convert Access 2000 to Access 97 - Toolbox for IT Groups7/22/2012 4:10:13 PM
Anyone know of a free standalone program that will convert an Access 2000 db to Access 97? -Nick