Error 62436 Funtion isn't available in query expression

[PookaTech]

Hello Everyone,

I am using A97 and am having a peculiar problem. I have just secured a database using group and user level security. The secured copy works fine on computers with Windows NT, but computers with windows 2000 are getting an error while running a query. The error is Run-time error '62436' and says "Function isn't available in expressions in query expression 'left("happy",2)'. The query runs fine in the unsecured copy.

The field is in a select query. On the computers running NT it evaluates to "ha" correctly.

Thanks in advance for any help,
PookaTech

 

[PookaTech]

Pat,

Thanks so much for your help. Indeed the problem was that the Win 2000/Excel 2000 computers have Microsoft Excel 9.0 object library instead of Microsoft Excel 8.0 object library. When the 2k computers open the program the computer automatically selects the 9.0 library, but in the process it misses something. Unselecting the 9.0 library hitting ok then reopening the references and reselcting the 9.0 library did the trick.

Once again thanks for pointing me inthe right direction.

PookaTech