A97 to XP A2002 conversion glitch

[Jawaahir Dance Company]

Thank you for any assistance you might provide.

We recently upgraded our system from Office97 to XP and
converted our Access97 to Access2002.

The difficulty we're encountering is in a database we use
for fundraising. The 'date' field no longer contains the
date of donation but instead holds the text "#Name?".

Have you encountered this before and what might I try to
fix it.

 

[Douglas J. Steele]

Your references are probably messed up.

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and
where it's being run (or the file missing completely from the target
machine). Such differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug 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)

For far more than you could ever want to know about this problem, check out
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[Jawaahir Dance Company]

-----Original Message-----
Your references are probably messed up.

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and
where it's being run (or the file missing completely from the target
machine). Such differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug 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)

For far more than you could ever want to know about this problem, check out
http://members.rogers.com/douglas.j.steele/AccessReferenc eErrors.html

You rock, Doug!

Thank you kindly for the assistance. Thanks also for the
link to the reference site. I'd seen that cited below in
answer to someone else's problem and had already printed
it for reference.

This database was created several years ago - I'm not
sure by whom or if they (or their computer) are still
with the group. I'm just doing some volunteer hours to
earn free classes.

I will follow your instructions and attempt to get it
fixed.

 

[Jawaahir Dance Company]

Argh!
There was a missing reference, " Microsft DAO2.5/3.5
Compact ..."

I unselected it and backed out - now, every date field is
filled with today's date and several other fields have
gone to the 'dark side'. The $ field shows $0.00 for
everyone and another field is blank.
I went back into the dialog box and I can't find that
reference in the list to reselect it.

Thank goodness I experimented using a copy, eh?

-----Original Message-----
Your references are probably messed up.
If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog.

NOTE: write down what the references are before you delete

them, because they'll be in a different order when you

go back in)

 

[Douglas J. Steele]

You don't want to use the Microsoft DAO 2.5/3.5 Compatibility Layer with
Access 2002. That was intended for use in Access 97 with databases created
in Access 95.

If the database has been upgraded a few times, you may have to bite the
bullet and update some of the code to use newer constructs.

 

[david epsom dot com dot au]

Typo -

Access 2002. That was intended for use in Access 97 with databases created

in Access 2.

(david)

 

[Douglas J. Steele]

Yup. Thanks for the correction, David.