Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query not updateable

Status
Not open for further replies.

rjs

MIS
Apr 6, 1999
632
US
Philhege was able to help with the last one, perhaps he or anyone else can help with this one.

I've been running CF 3.1 using Paradox databases for years, no problem. Got a new server IIS5/W2000 with CF 4.5.1 When I try to do <CFQUERY> to UPDATE a database I now get S1000 Operation must use an updateable query error. I've doublechecked rights - given SYSTEM full rights to the tables, even gone as far as giving EVERYONE and IIS user full rights to the tables directory - no luck.

The scripts ran perfectly under CF 3.1 and no changes have been made. Search of CF forums at Allaire produced no useable results.


Any help/suggestions would be greatly appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top