MID & LEFT functions don't work with Windows 98 1

[KavJack]

A week ago I had Office 97 running under Windows 95. I had to upgrade to Windows 98. Now my SQL containing functions LEFT and MID won't work. InStr is working though.
What do I have to do to get my SQL working ?
This SQL is suposed to find all teams named United in a database and replace it with a U;
i.e. Abingdon United becomes Abingdon U
UPDATE [CP1996P]
SET [CP1996P].AT =
Left([CP1996P].[AT],InStr([CP1996P].[AT]," United&quot) & "U"
WHERE (((InStr([CP1996P].[AT]," United&quot)>"0&quot) AND YR>1999;
I understand that there were some other people find problems running Office 97 in WIndows 98 but I could not find any resolution.

 

[ghubbell]

Well today seems to be double posting day so...(maybe it's the date)
Gremlins...
KavJack, Check in VB Tools-References. You need MS DAO 3.6 Object Library and possibly VB for apps Extensibility 5.3 . The priority is really important so try to compile the code, then if unsucessful, move them around till it does. On the computer in front of me (2000) I have VB for Apps, MS Access 9.0 (97=8), OLE Automation, DAO 3.6 (97=3.5x) and ActiveX D.O. 2.1 in that order. No "Missing" stuff either. If this fails, make a new empty Db and import all your old stuff (don't forget tool/menu bars) in to the new, and try again. Gord
ghubbell@total.net

 

[KavJack]

Thanks for your reply. Apparently I only have MS DAO 2.5/3.5 compatability library.
and a MISSING: MS DAO 3.51 Object Library.
Where do I find "MS DAO 3.6 Object Library and
possibly VB for apps Extensibility 5.3 "
How do I fix the MISSING: statement.

I show a VB for apps Extensibility but no version number.
Sorry for the double posting. I didn't anticipate spending my weekend trying to fix this problem. A PC person recommended that I upgrade to Windows 98. I'm not that familiar with all the innards of Office.

 

[ghubbell]

Hi KavJack,
Simply uncheck it from your list, but in any case push it to the "bottom of the heap". That is at least the one you need so if you can't find it somewhere on your list, try the second step (new empty Db) open a fresh module to check if it is there. If it is, you're on your way-import all your stuff. If not, I think you will have to reload Access in to the computer. Hope you get it fired up! Gord
ghubbell@total.net

 

[KavJack]

Your last suggestion was a winner !
First I did a search on the Internet for DAO36*** etc.
and while I was downloading something called JET40SP5
I tried your last suggestion. I created a new Access DB
and copied the Table and Query into it. Then the LEFT function started working again and the DA03.51 showed up as no longer missing. SO now I know what to do.
My last question for you is - do I need the JET40SP5 stuff that I am downloading now ?

 

[ghubbell]

What's the expression...if it ain't broke don't fix it? I think I'd let it be 'cause I think Jet4 might be for 2000 only. Thanks KavJack. Glad to help! Gord
ghubbell@total.net