Function not available 1

[scasystems]

Developed a system using access. with vb front-end.
Come against a problem where sql query is coming up with :-

Function is not available in expressions
What seems to be the problem is access is not recognizing basic expressions of left, mid, right, trim, date

Have attempted various versions of mdac_typ.exe
Tried various forums. no answers.

 

[lynchg]

You would need to give more of an explanation of how you are running into a problem. Those functions are all available in Access.

 

[scasystems]

My point entirely!!!!!!!
Since deploying our package onto various operating systems/office versions etc we ran into this problem.
It has something to do with the version of mdac_typ.exe.
I have another machine exact same specs and works fine.
The only diffrence is this machine has mdac_typ.exe v2.8 the working one has mdac_typ.exe v2.5
Yet another machine with office pro / and mdac v2.8 works fine??????

 

[lynchg]

You might want to try rolling back from v2.8 to v 2.5. I believe there is info on this at the Microsoft site.

 

[dhookom]

This is usually a references issue. Check Doug Steele's page

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Duane
MS Access MVP
Find out how to get great answers faq219-2884.