A97 db fails on new WindozXP machine

[LittleSmudge]

I have an Access97 database that has been running fine for years on many machines ( Win98, 2k, XP ) however, one user has just got a new machine ( Windoz XP ) and now she is having problems.

On one form the RecordSource is like
"SELECT * FROM tblOwnerDetails ORDER BY Left([FileRef],3), WalkOrder;"

When the user goes to open the form she gets
Function isn't available in expressions in query expression Left([FileRef],3).

I've copied the RecordSource text into a dedicated query and get the same result.

Yet it works on all sorts of other machines.

Any idea what might be wrong with the set up of this machine ?




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[PHV]

Check the references:
when in VBE menu Tools -> References ...
Do the database compiles properly ?
menu Debug -> Compiles ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[LittleSmudge]

Yes it all compiles correctly PHV - that was the frustrating thing.

I remembered that I had come across a similar thing in code when the References were in the wrong order between DAO and ADO - so I went and looked at the References ( as you suggest ).

Nothing missing, but I did notice the DAO was at 3.5

So I changed it to the 3.6 library and hay-presto it's all back working again.


Thanks for your time again PHV.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[smedvid]

I've had similar issues in the past where (1) user is having issues and the other dozen are A-Ok. My typical approach is to have MS Access re-installed on the troubled PC. It has always solved my problems. In my case, we have Access-97, Access-2000, Access-2002 (XP) and Access-2003 on all corporate PCs. So, I suspect if you have multiple versions, it could be a cross version or system library file issue. htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

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