Overflow error 6
A newsgroup poster had the following very standard lines of code
strSQL = "SELECT Mytable.Field1, Mytable.Field2, Mytable.Field3 FROM Mytable"
SET rs = Currentdb.OpenRecordset(strSQL,dbOpenDynaset)
The error was Overflow error 6.
He then replied a day later indicating that one of the variables in his code had been defined as an integer when it should've been a long. Now this is rather obscure although, once you think about it, quite understandable.
As a matter of course I always use Long fields for integers even if there will only ever be a few hundred records in the table. So I would like to think I would never have seen this message. But you never know.