J
jwolgy
I have an Access 2007 SQL Pass-Through Query to MS SQL Server 2000
that executes a stored procedure with parameters. The SP just inserts
some rows in a table and returns an integer as a return code
indicating success or failure. When the "ReturnRecords" property is
turned on so the code is returned to the client, it appears that the
query runs twice since the table shows twice as many rows inserted
than it should. When the "ReturnRecords" property is turned off, the
correct number of rows are inserted. This is a strange bug. Any ideas?
I'm using an ODBC connection. The same Pass-Through Query does not
display this behavior in Access 97.
that executes a stored procedure with parameters. The SP just inserts
some rows in a table and returns an integer as a return code
indicating success or failure. When the "ReturnRecords" property is
turned on so the code is returned to the client, it appears that the
query runs twice since the table shows twice as many rows inserted
than it should. When the "ReturnRecords" property is turned off, the
correct number of rows are inserted. This is a strange bug. Any ideas?
I'm using an ODBC connection. The same Pass-Through Query does not
display this behavior in Access 97.