inserting into access gives error

Results 1 to 2 of 2

Thread: inserting into access gives error

  1. #1
    suresh Guest

    Default inserting into access gives error

    hai,<BR>when i try to insert records intoa access database through access it gives an error. error message is .<BR><BR>Microsoft JET Database Engine error &#039 80004005&#039 <BR>Operation must use an updateable query. <BR><BR>when i copy the sql statement and run it on the access it does not show error.<BR><BR>Please help immediately<BR><BR>Thanks suresh<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: inserting into access gives error

    You need to give IUSR_[MachineName] write privelidges to your Access Database....<BR><BR>go to the folder where the file is contained and right click to get properties..then security and then add the IUSER_[MachineName] (Where Machine Name is the name of the machine (obviously!) )<BR><BR>Give it read & write privelidges....that should fix it.<BR><BR>Regards,<BR><BR>Carl.

Posting Permissions

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