I have an access database in the same directory as my vb.net program. I am trying to create the connection string in code and open the connection. My design time connection works fine but when I hardcode it by copying and pasting the conn string, it gives me an unknown error. In design time, I create a server db connection in the server explorer window and am not sure if I need to do this (or how to do this) in code.

Also, if I am referring to the same directory level how do I specify it in the conn string ? For example, this is what I tried

ConnString = ".....DataSource = ../mydb.mdb........"

This is the original path generated in design time

ConnString = ".....DataSource=C:/PROJECTS/mydb.mdb........."

Please Help.
Thanks