dsn less - updateable recordset

[nadskram]

I am using a dsn-less database and am receiving errors on my web server when trying to update a recordset using a disconnected recordset.

there are two functions i wrote, one to get an updateable rs and one to receive a recordset and update the database.
It works on a dsn databse, but now that i am re-writing the site and want to develop with a dsn-less database and receive the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query

it works here at my house where i initially tested it, but on the web server it doesnt.

code is like the following:

set rsUse = GetUpdateableRS()

with rsUse
.addnew
.fields("whatever&quot.value="Something"
.update
end with

UpdateRS(rsUse)

Where GetUpdateableRS and UpdateRS are functions I wrote

does the dsn-less connection have something to do with this error?

 

[Animation]

Do it manually instead of call it from the function

Regards,
Mathan.