I need to connect to a local access97 db with vb6.
but the program should work on serveal different machines.
so how do i refer to my database.

dim db as Database
set db=OpenDatabase("mydb.mdb")

doesnt work even if the file mydb.mdb is in the current directory.
it works with the compiled exe file
but gives me an error saying that it couldnt find the file.
Does anybody now a soulution for this?