Selasa, 03 Desember 2013

[MS_AccessPros] MS/Access 2013 creating problems w old simple database

 

I have fallen off the ranks as a “professional” but I still use the product.  I did not deliver any MS/Access as an executable – I delivered the database to be used and modified as desired by the user. 

 

Several built-in functions have been running for years.  Recently machine was upgraded to MS/Office 2013.  Now any query which builds an expression using a function is failing. 

 

Example:

 

RallyJumpHt: IIf(Right([class id],1) In ("5","6"),"00",[cjmpht])

 

Error message is:  Undefined function 'Right' in expression

 

This brings you to an answer from the msdn.microsoft.com site:

Undefined function <name> in expression. (Error 3085)

 

***

 

Is there a library that the database should be referencing which was lost when the 2013 was introduced?

 

pat fallon

mechanicsburg, pa  (http://www.pat-larry.com)

pat@pat-larry.com

 

 

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar