[RESOLVED] Clueless on Database

[salvelinus]

Hi,

I am using ADODB to connect to a MS Access 2003 database from my VB6 program.This is what i have to conect to my database:

'This doesn't connect to any database. It creates a connection object
Set rdAccessconn = New ADODB.Connection '*** connect to db
With rdAccessconn
On Error GoTo ErrorHandler 'this typically goes at the top of the sub

'this isn't a valid connection string. Check www.connectionstrings.com
.ConnectionString = "dsn=phonebook"
.Open
.CursorLocation = adUseClient
End With

However,no matter how many chnages i've made to my database,it just wont change my VB output.Anyone help me with this?Thanks in advance.

I usually work in Access alone, using DAO, so use the comments above with that caveat.