This works well now in Build 4044
However, it should be noted that whilst PHPrunner is open on the project, you get errors web application due to the file being lockedby PHPrunner:-
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Excel Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in D:\My Files\Documents\PHPRunnerProjects\PHPrunner52 Projects\Project4\output\include\dbconnection.php on line 7
Fatal error: [Microsoft][ODBC Excel Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. in D:\My Files\Documents\PHPRunnerProjects\PHPrunner52 Projects\Project4\output\include\dbconnection.php on line 10
It would be good if the PHPR output page would release the ODBC connection just after build and reinstate it when moving back to the pages where it needs it.
(Incidentally, the direct spreadsheet access does not share this problem but I can only get this to work readonly due to this error :-
Not Found
The requested URL /dvdsdirect/function.odbc-exec was not found on this server.)