Problem on using Round Function in VB

E

EDDIE

Hi !!

I have a problem on using Microsoft Access to update a record in my VB
problem.
I am using ODBC to connect to my DB.
When my SQL have a round function, it will prompt the error of 'Round' is
not a recognized function.
Why ?? I know there are 'Round' function inside the MSaccess ..

Hope someone can help me.
Thanks ..
 
D

Douglas J. Steele

When you're running queries from outside of Access (such as from VB), you're
strictly going through the Jet Engine, which doesn't know anything about VBA
functions such as Round.

Afraid there's no real way around this.
 
E

EDDIE

hi..
After i try to re-install the visual studio Service pack .
The SQL can work again .
i think may be some file corruption .
Thanks for all ..
 
Top