Right me laddos!

How can i tell an ADODC to look up a database in the current directory of the program.

i believe ive tried ".\main.mdb" , "main.mdb" and "\main.mdb"

BUT I JUST CANT DO IT!!!

plz help me if u can, cheers!