C
CBKowitz
I have two applications one written in Access 2002 using ADO and the other
written in VB.NET using ADO.NET. The Access application looks for files and
runs an associated process once the file is found. The VB.NET application
actually searches folders and subfolders for the specfied file and if it's
found it write that information to a SQL table using ADO.NET. Access uses
the Shell command to run the .NET app. When the .NET app is done running
control transfers back to Access. Access reads the SQL table with ADO by
calling a stored procedure and returning a recordset. The problem that I'm
having is sometimes the record(s) returned by the stored procedure are the
records from the previous search. I've confirm that the table contains the
correct information. How do I get ADO to return the actual contents of the
table and not some 'cached' version of the table?
Thanks.
written in VB.NET using ADO.NET. The Access application looks for files and
runs an associated process once the file is found. The VB.NET application
actually searches folders and subfolders for the specfied file and if it's
found it write that information to a SQL table using ADO.NET. Access uses
the Shell command to run the .NET app. When the .NET app is done running
control transfers back to Access. Access reads the SQL table with ADO by
calling a stored procedure and returning a recordset. The problem that I'm
having is sometimes the record(s) returned by the stored procedure are the
records from the previous search. I've confirm that the table contains the
correct information. How do I get ADO to return the actual contents of the
table and not some 'cached' version of the table?
Thanks.