Send Update Statement to SQl 6.5 
Author Message
 Send Update Statement to SQl 6.5

I am trying  to update a record in a table using an Update statement.
Im using Access 97 for the frontend and SQL 6.5 for the back end.
I can create an update query in access and then use the docmd.OpenQuery
method, but, isnt there a similar way to use the qdf.Execute or db.Execute
with this?
When I attempted to do this I got the following msg;
Error # 3003:   Couldnt start transaction; too many transactions already

(In some other attemps I got the err:  "to few parameters, expected 1"
however, I can't remember exactly what code produced that error)

Heres the code I used:

Function TestAddNew2()
    Dim wsp As Workspace
    Dim db As Database
    Dim strSQL As String
    Set wsp = DBEngine(0)
    Set db = CurrentDb() '

    strSQL = "UPDATE Code_ACI SET CdACI_Type = 'tttttttt' WHERE CdACI_ID =
    db.Execute strSQL, dbFailOnError

End Function

How can I do this?
What other options do I have for updating this record?


George Padvorac

Tue, 13 Jun 2000 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Dynamic SQL Statement With SQL 6.5

2. VB5: Updating recordset on MS SQL-Server 6.5

3. Error doing update with VB 3.0 and SQL Server 6.5

4. ERwin 2.5 Cascading Deletes/Updates with MS SQL 6.5

5. DAO Update Deadlocks SQL Server 6.5, but not 6.0

6. Update problem with VB6 and SQL Server 6.5

7. sending parameters from VB 6 to SQL 6.5 stored procedure

8. Error 10095 with SQL Server 6.5 and updates with cursors

9. VB5/ADO/SQL 6.5 currency field update fails?

10. sending null back to sql server 6.5

11. sending parameters from VB 6 to SQL 6.5 stored procedure

12. Sending a image to SQL Server 6.5


Powered by phpBB® Forum Software