paulie

Easy. Import System.Data.OLEDB, then connect with this code: [COLOR=#0000ff]Dim[/COLOR][COLOR=#000000] sAccessConn [/COLOR][COLOR=#0000ff]As[/COLOR][COLOR=#0000ff]String[/COLOR][COLOR=#000000] = [/COLOR][COLOR=#0000ff]"[/COLOR] [COLOR=#0000ff]Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Northwind.mdb;Jet OLEDBDatabase Password=YourPasswordIfNeeded"[/COLOR] [COLOR=#0000ff]Dim[/COLOR] oAccessConn [COLOR=#0000ff]As[/COLOR] OleDbConnection = [COLOR=#0000ff]New[/COLOR] OleDbConnection(sAccessConn) [COLOR=#0000ff]Dim[/COLOR] cmdAccess [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] OleDbCommand("Select * from Whatever", oAccessConn) [COLOR=#0000ff]Dim[/COLOR] adoAccessReader [COLOR=#0000ff]As[/COLOR] OleDbDataReader = cmdAccess.ExecuteReader adoAccessReader.Read() [COLOR=#0000ff]If[/COLOR] adoAccessReader.HasRows [COLOR=#0000ff]Then[/COLOR] 'Do Stuff [COLOR=#0000ff]End[/COLOR] [COLOR=#0000ff]If[/COLOR] adoAccessReader.Close() [COLOR=#0000ff]If[/COLOR] oAccessConn.State …

Hi Folks, I have a VB 2005 app (2.0 Framework) that I've published out to one of our fileservers in our company, so users can download/install and run it. It published fine, but when I go to install it on another PC (which I'm logged into with Admin rights), I …

Hi, You need to specify OLEDB in your connection string. Here's Microsoft's native OLE DB provider: [QUOTE]Public Const ORACLE_MS_OLEDB_CONNECT As String = "Provider=msdaora; Data Source="[/QUOTE] That's for connecting to Oracle. The best source for connection strings is: [URL]http://www.connectionstrings.com/[/URL]