#Ms access runtime error 3622 code#
Didn't change the saved queries or the code in any way - it just worked normally after manually executing one time. If I run the query manually once, then run the query via the function,Įverything works OK! I did it with the MDB, stepping through the code, thenĪgain with the MDE. In February without problems - I basically use this code any time I run an append, update, or delete query, to log/document any changes to data since none of my forms have the tables themselves as the record source. Now this function was written over a year ago, and the queries were deployed That's how I know which query fails since I run a few in order. Got to a flag called ErrorHandling, which runs a SQL statement (DoCmd.RunSQL),Īppending the login name, query name, and error number, if any, to a table. At the beginning of the function I set it to Queries, I just do the following after passing the parameters to QueryName: Then I run different statements based on the type of query. Set QueryName = CurrentDb.QueryDefs(strQueryToRun) Has anyone else? Any ideas?īasically, I set the query as follows ( strQueryToRun is the name of the savedĭim QueryName As QueryDef 'the actual query object I have programmed VBA in Access since Access 97 and have never seen this happen before. Not only did the query execute with no problem, once I ran the query using the function again, the query ran fine!!!
#Ms access runtime error 3622 update#
It is a random occurrence in that it does not seem to have any warning, but it does only affect a few (at the moment, four) update queries.Īfter I had identified the queries that failed, I ran each one once, manually, typing in the same parameters that were passed by the function. Certain saved queries have been failing when run by my function. However, in the last couple of days I have had a weird problem I’ve never seen before.
I used it with ACC2003 a few months ago and implemented the app as an MDE. The function has worked flawlessly for over a year I have used it in ACC2000 and ACC2002, in multiple implementations, all without error. It splits a string into an array, passes the parameters to the (already saved) query name, then runs the query using the Execute method, etc., then writes a record to a table that logs the name of the table and whether the query works or not. I have written a function that executes action parameter queries given a name and a list of parameters.
0 kommentar(er)
