>Even though I can add, amend, and delete records in a table in a SQL server using SQL passthrough and can create a view too using an odbc driver to create a connection
>What I don't know is what the best way of having either of these as a record source in a grid, I would like to requery this grid at regular intervals, say one a minute

IMO cursoradapter, as you do not even to look into SafeSelect technique to be used as a source for grids.

llOK = caYourTable.CursorRefresh()

>Think i'm missing the bleedin obvious here, but can anyone put me out of my misery?

Done ?

;-)