would the following code and process cause database to deny access/exceed connections?
set sql statement
open connection with sql
put results into data set
Missing something funamental?Code:dbCon.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = " & vmdbfile sql = "SELECT * FROM TABLES" 'data adapter da = New OleDbDataAdapter(sql, dbCon) da.Fill(ds, "pie") dbCon.Close