>>It is pretty much agreed upon by those that "actually do the work" that updates though recordsets is not only a bad idea, it does not work reliably.
>
>And who are those people? Names, please. I'm sure we all are eager to hear who is actually doing all of the work out there. Are you SURE they all agree? Names, please. Documentation of where they have all "pretty much agreed"?
>
John is right on here. Updating with record sets is easy, but not the best way to do things. To put things in a Fox perspective, think of the difference between remote views and SQL Pass Through. Now you get the idea between updating with a RS or using the Command object.
For the record, I have read from many sources that you will get much better control and scalability if you don't update from an RS. You need to call a Stored Procedure via the Command object.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer