Update Access Problem

[yangyang-rexxar]

Hi,Engineers

    I have an Expression Error from access.Please watch the diagram,Sentense on Line 5 is    
UPDATE AnalogInputVoltage SET Max=8.00,Min=7.00,Units=0,Terminal=0

where Channel='Dev1/ai5';

The sentence has no prob,but Labview have a 'update expression error'

[devchander]

Hi,

Plz post your code or a snapshot of the error message that pops up

[yangyang-rexxar]

Hi Devchander:

    My Access is Chinese version,Please get the link underside.It means Syntax error for Access.

paulbin

China

[Crystal]

The error message states that the expression error comes from the Jet Database Engine and not LabVIEW.  I recommend using the query building utility in Access to make sure the syntax is correct before hardcoding the strings in your VI.  I believe that "min" and "max" are reserved words in Access and you'd therefore have to change the names of those fields; I'm not certain, so check it first in Access.

[yangyang-rexxar]

Hi crystal：

    I followed your advice,The sentense
UPDATE AnalogInputVoltage SET Max=8.00,Min=7.00,Units=0,Terminal=0 where Channel='Dev1/ai5';was successful in Access.

I have no ideal.

[yangyang-rexxar]

It's a snapshot for DB Tools Execute Query.vi