SQL Problem?

[Slonoma]

Why does this statement:

UPDATE Table SET Field = (Left([Field],6))

Work in Access 97, but not in Access 2000?

 

[JeremyNYC]

Have you compiled the database in 2K? You may be missing a reference to some library, or you may just have a compile error that's getting in the way.

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Professional Development for Clients Large and Small

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[smedvid]

I've seen similar issues when there is mpore than 1 version of Access loaded on a PC. As mentioned, review the library references. Also, check out the priority of these library references. The issue I had was that a function was referenced in Excel, and the function I wanted was in Access-97 Utility library. Changing the order of priority fixed the issue for me.. htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[Slonoma]

smedvid,
It looks like thats what the problem is. However, it is only giving me this error on certain machines. Why only certain machines?

 

[smedvid]

I believe it is related to issues with precedence of libraries or other DLL References in the PC's Windows registry. In my case, I had the flexibility to convert the system(s) to Access-XP and.or have the PC's wiped clean and re-imaged with MS Access 97, 2000 and XP installed in the appropriate order. I found a white paper somewhere on the net that discussed loading (3) versions of Access... could not locate link though...

htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...