New record added in ODBC table

[GordonRS]

Good morning all!

I have an ODBC link in an Access 2002 d/b to an AS400 table (with the ODBC refresh interval set to 10 seconds) and as the data changes, the data in form view changes just fine and dandy, thank you very much.
However, when a new record gets added to the AS400 physical file, the recordset doesnt update to show this, even if I use records>refresh. I have to close the form down and re-open it to see the new record.
Is there a method to achieve this?

Thanks!

Gordon

 

[GordonRS]

Hi Pat!

Thanks for the reply.

I should have said I was just viewing the data in datasheet mode from 'tables'. It just intrigued me that the datasheet view automatically refreshed existing rows with any changed data but simply ignored new rows being added.
Perhaps I should explain what I am trying to do. We have a GPRS application that will put incoming transactions in the form of a new .txt into a folder. I want to detect their arrival and import the data into a database. Oh, and the data is multi-lined (shame its not in XML format!).

Just kicking the dust in the hope of inspiration, really!

Gordon