>Thanks Cindy... You are exactly right. I have quite a few that already work and some are really complex. I chose ADO because I want to be able to web enable many of my future apps. Perhaps ADO was not the best choice. I am relatively new to doing things this way. We have previously been just opening tables or using the DE.
>
>I wonder what most others use to build their data layer around?
>
>Seems that ado is probably the most flexible solution in the long run after finally getting things converted over.


If you are going to the web, then Crystal is an excellent solution. It has very powerful web capabilities.