Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    halifax
    Posts
    2

    Unanswered: read only database problem

    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 ?

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    What is the exact error you are receiving ? Which line is it failing on ?

  3. #3
    Join Date
    Dec 2002
    Location
    halifax
    Posts
    2
    it is giving me the database is read only error ;
    so maybe its my web admin problem and not my code

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Let me know if any of these articles help:

    article 1
    article 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •