ODBC Error Code = S1000 (General error) 1

[tonny]

if I want to update an access DB whit an ColdFusion script<br>
I get the following error:<br>
<br>
ODBC Error Code = S1000 (General error)<br>
[Microsoft] [ODBC Microsoft Access 97 Driver] Operation must use an updatable query.<br>
<br>
How should I resolve this<br>
<br>
thanksalot<br>
<br>
Tonny

 

[DarkMan]

What code are you using that causes the error? <p>Doug Trocino<br><a href=mailto:dtrocino@tecumsehgroup.com>dtrocino@tecumsehgroup.com</a><br><a href=

http://www.tek-tips.com>Tek-Tips

Forums</a><br>Web Application Developer<br>
Tecumseh Group, Inc.<br>
Sponsors of Tek-Tips Forums<br>

 

[tonny]

CFQUERY<br>
<br>
and it's about a field of a Date/Time type<br>
(mm/dd/yy).<br>
I had to change the regional settings of NT server<br>
from DD/mm/yyyy to mm/dd/yy.<br>
<br>
so now it's solved.<br>
<br>
But thanks for your fast reply.<br>
Appreciated<br>
<br>
greetings <br>
Tonny Wijnand<br>