>>>There are Northwind for SQL and Northwind for Access... The one I'm using is for Access.<
>
>Oh, darn. I was hoping it was SQL Server, because I was going to suggest looking at SQL Profiler and see what SQL command actually gets sent back to the server. I'm not at all familiar with Access. Is there some way of doing something similar with an Access database?
>
>~~Bonnie

This is a sample app I'm building...eventually, soon I hope, I'll be switching it over from a VB desktop/Windows app to a Web app...I'm not really fluent with either environment tho.

In an earlier implementation I places code to connect, open, do stuff to, and close my data inside each function that needed such things.

In my current implementation I used the wizards for the DataAdapters and DataSets and bound my DataGrid and textboxes to fields in my DataSets. I didn't explictly write any code to connect, open, or close my data.

I'm wondering how this works? (As you know there are parts I don't have working)
Does using the wizard approach result in my connection and files being open during the entire time my app is running?

When I switch 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?

Thanks...