Congratulations !! After few days digging into this issue, i finally found the problem, in reward for your time, will share with you my experience...
The code was placed on the before delete event of the form, since apparently access already sends a delete request for sql agent on this record, therefore querying this row was sort of blocked by that pending delete process...solut ion-just placed the code on the delete event and it works!...
bfuchs
Last Activity: Apr 4 '13, 08:13 PM
Joined: Nov 27 '12
Location:
-
Hi Neo, i appreciate you efforts to help me, and apologize for the misunderstandin gs.. its just that am in middle of converting a database and this is only one of the issues standing on my way..
to make a long story short, these 2 lines for example gives me that exact error :
ThanksCode:CurrentDb.Execute "delete * from PES where id = " & CLng(sID), dbSeeChanges CurrentDb.Execute sSql, dbSeeChanges
Leave a comment:
-
it took few seconds in query, while in code it runs forever...
even when trying to run the query thru code it fails.Leave a comment:
-
hi, when selecting opening etc its all fine, just going thru code that failsLeave a comment:
-
fyi- its an append query, in this case it has just one record to apply.Leave a comment:
-
hi to all, thanks for your reply!
the error is a timeout from the server
its being stuck at the following line
CurrentDb.Execu te sSql, dbSeeChanges
again, nothing is wrong with the sql, as i copy it to a query it works fine, with no delay at all!Leave a comment:
-
currentdb.execute odbc--call failed error #4134
Ben,
Hi,
First of all, here are my work tools : I have an Access 2003 app that uses an SQL Server DataBase (i know it's weird). I am using Microsoft SQL Server Management Studio Express.
I am now trying to execute a query from my app to insert some rows from 2 tables into another. My query works well when i use it rigth into SQL Server Management or when i create a new query in Access, but it don't work in my app... It gives...
No activity results to display
Leave a comment: