John...

The difference of working with an ADO command object vs. SPT is like night and day. For starters, the ADO command object has a parameters collection. This of course, is assuming you are using stored procs. If you are not, you are already behind the 8-ball. And, whether you work with SPT or and ADO command object, you are still rendering SQL from the client - which is very inefficient.

So, if you are rendering SQL updates from the client, THAT is the issue. The issue of whether to use SPT or ADO is a red-herring. In that case, it really does not matter.

If on the other hand, you doing thing things as efficiently as possible, using stored procedures, then ADO/OLE DB is a much faster and a much more efficient way of working with remote data - especially update operations.