Having problem with insert into query?

Results 1 to 3 of 3

Thread: Having problem with insert into query?

  1. #1
    Join Date
    Dec 1969
    Posts
    82

    Default Having problem with insert into query?

    Has anyone ever got this error message <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>What does it mean? here is my query<BR><BR>insertQuery="Insert into client_TBL(C_Date,C_FName,C_LName,C_Address,C_Tele , C_Email, C_SRep) Values(&#039;" & entryDate & "&#039;, &#039;" & FName & "&#039;, &#039;" & LName & "&#039;, &#039;" & Address & "&#039; , &#039;" & Tele & "&#039; , &#039;" & Email & "&#039;, &#039;" & SalesRep & "&#039;)"<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    733

    Default Aha, today's access permission post

    Check authorisation on mdb file and it&#039;s folder. IUSR_&#060;machinename&#062; must have permission to read/write on both.

  3. #3
    Join Date
    Dec 1969
    Posts
    82

    Default RE: Aha, today's access permission post

    Thanks someone has to post one it migght as well be me lol

Posting Permissions

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