OverFlow error #6 using strings in Win98???

[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

 

[Allen Browne]

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.