Access

[Fredn]

Can i open a database connection to an Acces 2000 database using a connectionstring?
(like i open a SQLserver database?)

The following code doesn't work; can you make it work?

'references: Microsoft ActiveX Data Objects 2.6 Library
 
Dim Conn As ADODB.Connection
Dim RS As ADODB.Recordset
Dim CS As String
 
CS = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=C:\ProjectsVB\Experiment\testdb.mdb;DefaultDir=;UID=;PWD=;"
 
Conn.Open CS

[newbiekea]

Private Sub Form_Load()

Dim Conn As ADODB.Connection
Dim RS As ADODB.Recordset
Dim CS As String

CS = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\ProjectsVB\Experiment\testdb.mdb;Persist Security Info=False"
Set Conn = New ADODB.Connection

Conn.Open CS

End Sub