Access 2K CurrentProject.Connection equivalent for Access 97 1

[RickBerem]

Hi,

I've been reading quite a few posts now but wasn't able to find the answer I was looking for. I want to find the Access 97 equivalent for Access 2K's

CurrentProject.Connection

I need that to access the current database with ADO from Access 97.

Dim cnn As ADODB.Connection

Set cnn = CurrentProject.Connection

Thanks for any help,
SG

 

[GHolden]

This may not be the best way (but it works!). When I use ADO in 97 I create a connection string that points to the db.

eg.

Public gcnnDB As New ADODB.Connection

cnnDB.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=Z:\Sample Access DB\Test.mdb;" & _
"Uid=admin;" & _
"Pwd="

I make a the cnnDB global and a public function to connect so you don't have to keep typing it in.

There are two ways to write error-free programs; only the third one works.

 

[RickBerem]

Thanks GHolden,

I thought of that but I was hopping there would be an option like

CurrentDB

to be certain that I dont' need to hard code the database path.

I guess I'll just use this option!

Thanks again SG