If you're using custom or built in functions in queries
that are being run from an Addin, you might experience a situation where
Access doesn't recognize the functions.
db.Execute "UPDATE tblObjects SET LastUpdated = " _
& "fGetLastUpdateStamp([ObjectType],[ObjectName])
" _
& "Where dbID=" &
Me.DBId, dbFailOnError
or
db.Execute "qryUpdateTimeStamp"
Where db=CodeDB()
Note that this may also happen with built in functions
such as NZ.
I am not aware of a solution to get it to work. You
will have to convert the query to DAO code.
|
