Re: SQL Data Written fm ADO.NET read fm ADO


"CBKowitz" <CBKowitz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1B4756A8-6FF6-46ED-8D6A-9FF0A14AF5EB@xxxxxxxxxxxxxxxx
| 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.

I hope I'm understanding your problem correctly. If so, then The
Jet engine caches info, and it appears that you're getting the
cached info from the previous search like you said.

Found this article that might be of help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;200300

Jim


.