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