OverFlow error #6 using strings in Win98???

  • Thread starter Thread starter SAG
  • Start date Start date
S

SAG

I know how to overcome this problem if I'm working with
numeric values but a string??? The following is an
example of the line of code that produces this error.

I dimmed APNumber as String. The vno field is 6 chars
wide.

If APNumber <> rsApp2.Fields("vno").VALUE Then

This problem is only resulting in my Win 98 PC and not my
WinXP nor my Win 2000 Server.

I'd appreciate any ideas that can help me.

I get the same error with the following line of code. The
name field is also
string type.

if IsNull(rsAPMaster.Fields("name").VALUE) then


Steve
 
Assuming you have the same Office service packs on both your platforms, the
most likely culprit would seem to be a corrupted index. That could cause
Access to attempt to access a record outside of the range of pointers for
the recordset, resulting in an OverFlow.

A compact/repair would be worth a try.
 
Back
Top