Access 2002 generates run time error 3157 ODBC update failed

T

TrilobyteMKR

If I run a query from the query grid using ODBC it works. If I run it from
VBA it fails with and ODBC run time error 3157.
This is my code
Dim stDocName As String

stDocName = "Qry_ClearAllFlagsinABIProjects"
DoCmd.OpenQuery stDocName, acNormal, acEdit

The query just updates 270 records setting a value to null
It normally runs in about 2 / 3 seconds.

I have run repair, updated sql server to sp3, copied the all of the access
objects to a new database, created a new dsn etc etc all fails.
Any suggestion?
thanks
Malcolm
 
D

deng

TrilobyteMKR said:
If I run a query from the query grid using ODBC it works. If I run it from
VBA it fails with and ODBC run time error 3157.
This is my code
Dim stDocName As String

stDocName = "Qry_ClearAllFlagsinABIProjects"
DoCmd.OpenQuery stDocName, acNormal, acEdit

The query just updates 270 records setting a value to null
It normally runs in about 2 / 3 seconds.

I have run repair, updated sql server to sp3, copied the all of the access
objects to a new database, created a new dsn etc etc all fails.
Any suggestion?
thanks
Malcolm
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Error 3157: "ODBC - update on a linked table <table name> failed 4
Help-ODBC Error when query runs 2
MAYDAY! MADAY! - Run time error 8
Docmd.openquery causes error 4
update query ODBC--call failed 3
Update Query ODBC --- call failed 11
ODBC Call Failed 2

Top