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/