What is the best way/practice when using Project Variables of type DB Table
We are using 12 project variables, all of DB Table type, to customize data that sometimes changes during developement of our applications.
Tests are running every night on several virtual machines (different windows and IE versions), but we often get the JScript runtime error "Microsoft Jet can't open file... already opened in exclusive mode by another user..." because one of our customers forgot to close the Excel file associated to one of our project variables after changing some parameters. When this happens, all the project fall in a FAIL state, and this is bad.
We thought about copying the Excel files associated with our DB Table Project Variables, but it seems the path or name of the DB Table Project File cannot be changed at run time.
Any suggestion welcome !
Tests are running every night on several virtual machines (different windows and IE versions), but we often get the JScript runtime error "Microsoft Jet can't open file... already opened in exclusive mode by another user..." because one of our customers forgot to close the Excel file associated to one of our project variables after changing some parameters. When this happens, all the project fall in a FAIL state, and this is bad.
We thought about copying the Excel files associated with our DB Table Project Variables, but it seems the path or name of the DB Table Project File cannot be changed at run time.
Any suggestion welcome !