I have a document which references an Access DB in the script using an ODBC connection. The line in the script looks like this:
ODBC CONNECT32 TO [MS Access Database;DBQ=C:\QVDOCS\Project1\ProjectData.accdb];
When I want to publish it, the path on the server is different than the one on my PC. I actually don't know the exact path, as it's on a server maintained by a different group. The database does sit in the same folder as my QVW file. Is there a way to remove the path from the ODBC connection statement, or tell it to use the same path as the file running it? I tried this:
ODBC CONNECT32 TO [MS Access Database;DBQ=ProjectData.accdb]; and ODBC CONNECT32 TO [MS Access Database;DBQ=\ProjectData.accdb];
