Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accessing Database internally

Status
Not open for further replies.

ravula2000

IS-IT--Management
Mar 8, 2002
205
0
0
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top