i am using frontpage 97 to connect to a remote server which my asp and access 97 mdb files reside on,,when i try run sql commands to update my database i get an error. i can pull records out of my database find an display them,,,.
i am using server objects,,here is an example of my code
Dim rsQuery
set rsQuery=server.createobject("adodb.recordset")
rsQuery.open"select * from data where Station = 'YOW'",myconn1,adopenKeyset,adLockOptimistic
rsQuery("Month")="Jan"
rsQuery.update
rsQuery.close
is this problem one of permissions which my server admin has to fix on his end ?