title: Change datasource for Dataset
body: <p>May I ask a question.</p>
  
  <p>I have a vb.net window application project that connect to Access database.</p>
  
  <p>I use dataset for all Forms and Reports.</p>
  
  <p>Now I would like to change back end from Access database to SQL Server 2000 database.</p>
  
  <p>I change the connection string(Data source, Data Provider etc)to connect to SQL Server 2000.</p>
  
  <p>But it is not convenience bcos Dataset Designer codes are still connect with OLEDB Provider instead of Sql Client Provider.</p>
  
  <p>So I can't do my application with SQL Server database.</p>
  
  <p>May I request suggestion how to do it.</p>
  
  <p>Thanks in advance. </p>