Is it possible to open 2 or more instances of InfoQube to work on the same IQBase file?
(i.e. You see 2 or more "InfoQube.exe" in the task manager)
 
The short answer is : YES.
 
More details :
  1. IQ uses Microsoft JET 4.0 as its database engine which is fully multi-user. Also, each field value is a separate database record, hence reducing the data corruption risk. So the bottom line is that you won't run the risk of corrupting your data by working on your database with 2 or more IQ instances. The only possible situation is that the second instance gets an inconsistent / outdated set of field-values. Nothing that a refresh would not solve...
     
  2. Note that all grid changes are saved on a refresh, so the other IQ instance grids will behave exactly as when you have the same grid opened more than once : that last refreshed/saved one "wins". To have two independent view of the the same data, save the grid under a new name (Grid > Save As...) and open one grid in one instance and the other in the other instance
     
  3. In Tools > Options, set 2.4.9 (Multi-user check) to 60 seconds or so, so data changes are seen by the other instance (UI changes do not auto-sync, only data)
     
  4. Concerning the VB scripts : The user code is loaded on startup (system, user) or when opening file (DB specific), so changes in one IQ instance is not updated in the other.
     
  5. To open a second instance of the same file, open IQ and do File > Open and select the file