Access 97 ADO connection to current database

[Tony Scandora, 630-252-7541]

Access 2000 can define an ADO connection to the current database as
Set cn = Application.CurrentProject.Connection

Access 97 can define the current database for DAO as
Set dbs = CurrentDb

How can Access 97 define an ADO connection to the current database?

Thanks,
Tony Scandora, Argonne National Lab, 630-252-7541
scan...@cmt.anl.gov

[Danny Lesandrini]

Dim cnn As New ADODB.Connection
Dim strConnect As String

strConnect = "Provider=Microsoft.Jet.OLEDB.3.51.1;" _
& Data Source=" CurrentDb.Name & ";"
cnn.Open strConnect

--

Danny Lesandrini
dlesa...@hotmail.com

Tony Scandora, 630-252-7541 <scan...@cmt.anl.gov> wrote in message
news:7sg974$r1u$1...@milo.mcs.anl.gov...