I am using Crystal Reports and VB with Access as my database. I create a ODBC connection in the control panel and point to the ODBC connection when I created the report in the design mode. everything works fine until I go to another machine with the same ODBC connection but everything is sitting in a different path. For some reason the report loses the ODBC connection. and I have to open it back up and reset the connection.

I thought the purpose of the ODBC connection is to find the database no matter where it is located as long as the ODBC System DSN Name is the same as the one set in the crystal report. Please correct me if I am wrong. or am I suppose to set something up in the VB app?

If anyone has a fix for this I would greatly appreciate it.