Determining the ConnectionString

[AccessCodeBoy]

I am trying to figure out how to determine the connection string for the current access databse running VBA. In Access 2000, I use the BaseConnectionString property of CurrentProject. However, this does not seem to be an available option in Access 97. Any one have any ideas on how to do this in Access 97?

 

[Alexandre]

Any luddite volunteers?

 

[The_Doc_Man]

According to my AC97 Help Files, the Connection property exists for a database or recordset object. That property points to a member of the Connections collection, which is a database-level collection.

I would get into the Object Browser and look into what can be gleaned from there as to properties you could examine.