faqts : Computers : Programming

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

3 of 5 people (60%) answered Yes
Recently 3 of 5 people (60%) answered Yes

Entry

how to connet to aceess in vb

Oct 26th, 2004 15:55
Tony Hughes, prasad chavan, http://www.exogenetic.com/


MS Access 97
connectionstring = "DRIVER={Microsoft Access Driver (*.mdb") & ")}; 
DBQ=c:\database.mdb" 
MS Access 2000 using virtual path
connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data 
Source=c:\database.mdb") 
MS Access 2000
connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data 
source=c:\database.mdb" 
MS SQL Server 7
connectionstring = "driver={SQL 
Server};server=SERVERNAME;uid=USERNAME;pwd=PASSWORD;database=DATABASENAM
E" 
http://shopping.exogenetic.com/