INSERT statement doesn't process in W2k

Results 1 to 2 of 2

Thread: INSERT statement doesn't process in W2k

  1. #1
    Scott Berg Guest

    Default INSERT statement doesn't process in W2k

    I have an insert statement in a site that runs perfectly on PWS (on a W98SE machine) that give me the following error when I transfer the site files to a Win2K Pro machine (I assume it runs IIS 5):<BR><BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)<BR>[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.<BR><BR>I&#039m using a DSN connection to the database, and I know that the connection is working because there are several data-driven pages that are accessed before the insert statement page, and the error comes on the line that tries to execute the INSERT statement, after the object has been opened.<BR>Any suggestions will be greatly appreciated.<BR>--Scott Berg

  2. #2
    Michael Lane Guest

    Default RE: INSERT statement doesn't process in W2k

    Without the statement and knowing the structure, it is hard to tell. Check permissions on the table(s), database, and file system that you are writing to to make sure you have more than Read abilities.

Posting Permissions

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