Connection String to Current Database 1

[Poduska]

I have been using this connection string which always refers to the database "Sales_Reporting.mdb". However, users have been creating their own copy of the database with a different name but the code always looks to the original MDB file and not the newly named MDB.

How can I make the "Sales_reporting.mdb" part below always just point to the Current database that is open?

    strConn = "Provider=Microsoft.jet.oledb.4.0;" & _
         "Data Source=" & CurrentProject.Path & _
       "\Sales_Reporting.mdb"

 

[JoeAtWork]

This should give you your current ADO connection string:

CurrentProject.Connection

That being said, you probably never really need the connection string because you could always just use the CurrentProject's connection directly, e.g.

rsADO.Open "MyTable", CurrentProject.Connection

 

[Poduska]

It's too easy!

It works great.

Thanks.