Trouble with access database

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default Trouble with access database

    I am working on an updatable calendar and i am running
    into trouble. The page works great when testing it
    through http:\\localhost, however when i change local host
    to the ip address i get
    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Microsoft Access Driver] Operation must
    use an updateable query.

    I have given the folder write access, just can't figure
    out what i am doing wrong any help?
    Adam Guest

  2. Similar Questions and Discussions

    1. Trouble connecting to Access database
      I uploaded my database to a remote server and I was required to change the name to match my DSN. However, now whenever I visit the web-site I...
    2. Trouble with database query
      Hi, THIS (Below) error keeps coming. I'm just trying to make a normal login page. It LOOKS fine to me, I've groomed it for bad spaces and...
    3. Trouble connecting to SQL database in .NET
      I am trying to connect to a SQL database in C#.NET (Dreamweaver), but can't get connected. In ASP and Visual Studio.Net I have no problems...
    4. Trouble with database access: can't edit record, just view it
      Hallo! I use DWMX 6.1 and use ASP VBSCRIPT files to access a MS Access 2000 database. Initially I was able to edit the records. Then I had to add...
    5. I need help. I am having trouble clearing a field in an Access database.
      I don't know what to use to clear a field in an MSAccess database. I can update fields in the database and delete whole records but I have not...
  3. #2

    Default Re: Trouble with access database

    Who has write access? IUSR?

    Also, instead of ODBC, use OLE DB. Get an OLE DB connection string at
    [url]www.connectionstrings.com[/url]

    Ray at home

    --
    Will trade ASP help for SQL Server help


    "Adam" <awally11@cableone.net> wrote in message
    news:016a01c35a0e$48669430$a501280a@phx.gbl...
    > I am working on an updatable calendar and i am running
    > into trouble. The page works great when testing it
    > through http:\\localhost, however when i change local host
    > to the ip address i get
    > Error Type:
    > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    > [Microsoft][ODBC Microsoft Access Driver] Operation must
    > use an updateable query.
    >
    > I have given the folder write access, just can't figure
    > out what i am doing wrong any help?

    Ray at Guest

  4. #3

    Default Re: Trouble with access database

    I am a little new to asp pages and database, but i changes
    the connection screen, now when i hit the submit button i
    have a windows logon for user and password trying to
    connect to my ip address, is there a was to add a user
    pass or a way to get around this or what am i doing wrong,
    thanks
    >-----Original Message-----
    >Who has write access? IUSR?
    >
    >Also, instead of ODBC, use OLE DB. Get an OLE DB
    connection string at
    >[url]www.connectionstrings.com[/url]
    >
    >Ray at home
    >
    >--
    >Will trade ASP help for SQL Server help
    >
    >
    >"Adam" <awally11@cableone.net> wrote in message
    >news:016a01c35a0e$48669430$a501280a@phx.gbl...
    >> I am working on an updatable calendar and i am running
    >> into trouble. The page works great when testing it
    >> through http:\\localhost, however when i change local
    host
    >> to the ip address i get
    >> Error Type:
    >> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    >> [Microsoft][ODBC Microsoft Access Driver] Operation must
    >> use an updateable query.
    >>
    >> I have given the folder write access, just can't figure
    >> out what i am doing wrong any help?
    >
    >
    >.
    >
    Adam Guest

  5. #4

    Default Re: Trouble with access database

    - Are you allowing anonymous access (via the IIS MMC Snapin)?

    - If so, does the IUSR_<machinename> have permissions to the ASP files
    themselves? (should be Read/Execute)

    Cheers
    Ken

    "Adam" <awally11@cableone.net> wrote in message
    news:019a01c35a13$d478c970$a501280a@phx.gbl...
    : I am a little new to asp pages and database, but i changes
    : the connection screen, now when i hit the submit button i
    : have a windows logon for user and password trying to
    : connect to my ip address, is there a was to add a user
    : pass or a way to get around this or what am i doing wrong,
    : thanks
    :
    : >-----Original Message-----
    : >Who has write access? IUSR?
    : >
    : >Also, instead of ODBC, use OLE DB. Get an OLE DB
    : connection string at
    : >[url]www.connectionstrings.com[/url]
    : >
    : >Ray at home
    : >
    : >--
    : >Will trade ASP help for SQL Server help
    : >
    : >
    : >"Adam" <awally11@cableone.net> wrote in message
    : >news:016a01c35a0e$48669430$a501280a@phx.gbl...
    : >> I am working on an updatable calendar and i am running
    : >> into trouble. The page works great when testing it
    : >> through http:\\localhost, however when i change local
    : host
    : >> to the ip address i get
    : >> Error Type:
    : >> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    : >> [Microsoft][ODBC Microsoft Access Driver] Operation must
    : >> use an updateable query.
    : >>
    : >> I have given the folder write access, just can't figure
    : >> out what i am doing wrong any help?
    : >
    : >
    : >.
    : >


    Ken Schaefer Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139