R
Rick Matus
I am computing the number of records in a subform that contain a particular
string, "CAT4*", like this
Forms![client sites].[Catia] = DCount("CustomerID", "Sales Data",
"([CustomerID] = '" & [CustomerID] & "' and [Selected] = -1) and ([Fee Type]
like 'CAT4*')")
This works fine, but when I try to synchronize replicas I get an error
message about the data I am trying to insert being larger than the field I
am trying to insert it into. I have other similar searches that work fine
and synchronize fine using different strings. In fact, my workaround is to
change "CAT" to "DOG" in the above search and in the records I am searching.
That works and synchronizes with no problems.
Why does using the string "CAT" in this search cause problems with
synchronizing replica databases?
string, "CAT4*", like this
Forms![client sites].[Catia] = DCount("CustomerID", "Sales Data",
"([CustomerID] = '" & [CustomerID] & "' and [Selected] = -1) and ([Fee Type]
like 'CAT4*')")
This works fine, but when I try to synchronize replicas I get an error
message about the data I am trying to insert being larger than the field I
am trying to insert it into. I have other similar searches that work fine
and synchronize fine using different strings. In fact, my workaround is to
change "CAT" to "DOG" in the above search and in the records I am searching.
That works and synchronizes with no problems.
Why does using the string "CAT" in this search cause problems with
synchronizing replica databases?