I know this is awful, making a connection to a database that you are in already, but just like ThisWorkBook.Path gets you the current excel path, how can you get the path for the database you are in.
My Code:
db.Open "provider=microsoft.jet.oledb.4.0;data source=" & "WHAT GOES IN HERE" & "Copy of TEST2.mdb;"
Thanks
Emily