I have a query that uses the between statement. This works fine under Access 97 and Win 95/98. However, when I open it in Access 97 & Win XP, I get a "can not resolve" error. Any ideas?
I can't imagine why, but I'd bet there's a very good chance that XP has either replaced, renamed, or removed a DLL that's needed somewhere in the process, by A97 and/or JET.
Have you tried RE INSTALLING Access/97?
If this does not work, try importing all the parts of your old database into a newly created one. You'd be suprised how many goofs this seemingly innocuous process fixes.
Jim
Me? Ambivalent? Well, yes and no....
Another free Access forum:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.