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 have the results of a system sproc that give me the date and time (as seperate fields) something ran.So I have the time last run as: 180001 I need to convert that to something more like 18:00:01 ...