>I really try to adhere to good n-tier programming, and so far our conversion of our backend from VFP to SQL Server has gone quickly and smoothly. I have 1 place where tables are opened, one place for certain types of database queries in my biz and data classes. For performance reasons, my report object didn't use the data or biz objects to get data, but accessed the tables directly. This is such a pain to convert. When I orginally had created my report object I had used my data tier and biz tiers to retrieve data, but the reports just became too slow.
>
>Just thought I would grumble a bit. :-)

Now you have a chance to make them slow again. :)