hi all, i have tried for an hour now to build an ado connection to open access database thru a n ODBC DSN.

I have created the dsn from the control panel, it's name is reports

now it doesn;t connect although if i used the location of the file directly , it works fine.

i need the right connectionstring for DSN source including a password.


by the way , i have checked www.connectionstrings.com , but the only thing for dsn is for VB6 conections.


PLz help in this issue

THX in advance

BST RGDS