D
david epsom dot com dot au
I have an update query run from a DAO QueryDef in Access 2000. One of the
Query Parameters has type "memo".
The query execution fails if the memo parameter has a text value (it
succeeds if the parameter is an empty string or null value).
I can type text into the table field: the query execution succeeds if the
query is run from the Access environment: the DAO Querydef execution
succeeds if the parameter type is changed from "memo" to "text".
Has anyone seen this before? Is it fixed by a later Service Release?
(david)
Query Parameters has type "memo".
The query execution fails if the memo parameter has a text value (it
succeeds if the parameter is an empty string or null value).
I can type text into the table field: the query execution succeeds if the
query is run from the Access environment: the DAO Querydef execution
succeeds if the parameter type is changed from "memo" to "text".
Has anyone seen this before? Is it fixed by a later Service Release?
(david)