I am running Win XP Pro with IIS5.
I have a ASP shopping cart setup (or not) and when i try to write information to the access database i get the following error.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
C:\INETPUB\WWWROOT\DIAGNOSTICS\../includes/databaseFunctions.asp, line 92
When i went to that line of code i got the following sub routine:-
sub updateDatabase(mySQL, rsTemp, scriptName)
if err.number <> 0 then
if pTrapDbErrors=0 or (err.number<>9 and err.number<>5 and err.number<>6 and err.number<>13 and err.number<>94 and err.number<>424 and err.number<>3265 and err.number>-2000000000) then
response.redirect "comersus_supportError.asp?error="&Server.Urlencode("Error in " &scriptName& ", error: "&Err.Description& " - Err.Number:"&Err.number&" - SQL:"&mySQL)
The company site is down because of this error and my employer is getting very cheesed with me so some
one please save my job.