updateable query

Results 1 to 2 of 2

Thread: updateable query

  1. #1
    jomeboo Guest

    Default updateable query

    why do i always get an use updateable query error when i try to insert data to our msaccess database in the host server.<BR>tx<BR>jome

  2. #2
    gwenda ellwood Guest

    Default RE: updateable query

    Hi jome:<BR>I was getting that error all the time too. 3 things fixed it:<BR>1) in Windows Explorer check out the permissions on your db file and the folder it is in<BR>2) use SQL query method on the connection object instead of using ADO .addnew, e.g. <BR> Dim objRS, objConn &#039declar vars<BR> Set objconn = Server.CreateObject("ADODB.Connection")<BR> objConn.Open("DSN=whateverYourDNSis")<BR> set objRS = objConn.Execute ("Select * from MyTable")<BR> objConn.Execute "INSERT INTO MyTable (field1, field2) VALUES (valueforfield1, valueforfield2)"<BR><BR>3) locate your Access database in a folder outside of the Web Tree<BR><BR>Hope this helps,<BR>Gwenda

Posting Permissions

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