How about using an adp? I know this would be a problem if you have a bunch of vba to update to ado, but to me it seems easier and...