Rick,

>>Does using the wizard approach result in my connection and files being open during the entire time my app is running?<

Probably not, but then it's been a long time since I've looked at any code that the wizards generated, so I'm not 100% sure what the code is. I don't use the wizards at all.

>>Eventually I'll be switching this over from a VB desktop/Windows app to a Web app. Is there a preferred approach to data access for Web apps? Is there anything special involved in switching a windows app to a web app? Will I need to start from scratch?<

One thing you should definitely do is to separate your DataAccess classes from your UI classes. That way, all the DataAccess functionality will be separate and it will be possible to use it from either UI ... WebForm or WinForm. WebForms are definitely another kettle of fish ... they won't be similar at all to the WinForms, so learning how to do a WinForm does not necessarily prepare you for how to do a WebForm ... but, they *can* share the same DataAccess methods (actually, I'd separate the DataAccess from the UI with one more layer ... a BizObject layer).

I hope that gives you a little food for thought. Have fun. =)

~~Bonnie