Ok in MSAccess I can send an SQL string to a server I'm connected to and as I understand it that string can contain anything.Basically it would behave as if I was connected to the server directly ...

I've got a products table that uses a next product id to allow versioning of products, e.g.:ID Model List NextID 1 A 1.00 2 2 A 2.00 3 3 B 2.50 4 4 B 3.00 NULLWhat would the best way of returning ...