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.
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.