Buffer Overflow

From: aprice (anonymous_at_discussions.microsoft.com)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 04:06:05 -0800

I have an applications that runs against a Microsoft Access 2000 database. The process is simple.... Pass a client id to a sql statement, opening a recordset. If the recordset comes back with a 0 recordcount, I add a new record, then populate the client id with the value passed, if there is an existing record, I simply update the client name and change the modified date and username to reflect the latest record changes. This simple process works on all my test machines, including Windows 98SE, ME, 2000 Pro and XP, and also the same OS on most of my clients machines. However, on two client machines, one 98SE and one XP, when attempting to add or modify a record within the recordset, I get a Buffer Overflow (6) error. I checkd the sizes and types for each variable and they are correct. Any idea's why this would work on most machines but not others?

Thanks in advance....