Refresh problem

S

Simon

Hello

I use Delphi with Access, with ADO.
I use some TAdoTables, connected to a TADOConnection.
So, I have this problem : When write with queries on the tables, and after I
try to execute some Select queries to find some records, I don't find the
new ones, I MUST close and open just after the ADOConnection and all the
tables connected to it.
Is there a better (I hope so !) solution to find the new records in the
tables ?

thank you
[email protected]
 
M

Michel Walsh

Hi,


You have to requery the recordset to be able to see records added by
others users ( the code is another user than the one in front of the
keyboard ).


Hoping it may help,
Vanderghast, Access MVP
 
Top