I have an Access97 frontend with an SQL backend. The following code generates the error "The Field is too small to accept amount of data try...." Why? I am not adding or inserting. I am just searching. Why?
Dim db As Database
Dim StrCriteria As String
Dim CustomersRS As Recordset
Set db = CurrentDb()
Set CustomersRS = db.OpenRecordset("Customers", dbOpenDynaset)
StrCriteria = "[ReminderDate] = #1/1/04#"