SQL Data Written fm ADO.NET read fm ADO

[Guest]

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.

 

[Val Mazur \(MVP\)]

Hi,

Ho do you connect to the SQL Server from the Access?

 

[Guest]

Trusted Connection through OLEDB with the SQL Driver

 

[Val Mazur \(MVP\)]

Strange. Then it suppose to work fine. Do you have some sort of delay or
not. Do you need to close connection to get latest records? Could you post
your connection string here?

--
Val Mazur
Microsoft MVP

http://xport.mvps.org