ravula2000
IS-IT--Management
Hi,
I created a form in the MSAccess database and Iam accessing the database with the following code which is working fine.
=================
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
cn.Open "dsn=csismdb"
Set rs = cn.Execute("select caseid, notes from CaseIdNotes")
rs.MoveFirst
======
As the form is in the database itself, is there a way to connect internally with out creating dsn, giving in mdb file name?
I used ADO here and suggest me what is the correct method.
Give me some code also if possible..
Thanks
Srini
I created a form in the MSAccess database and Iam accessing the database with the following code which is working fine.
=================
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
cn.Open "dsn=csismdb"
Set rs = cn.Execute("select caseid, notes from CaseIdNotes")
rs.MoveFirst
======
As the form is in the database itself, is there a way to connect internally with out creating dsn, giving in mdb file name?
I used ADO here and suggest me what is the correct method.
Give me some code also if possible..
Thanks
Srini