Hi Dorin
Maybe you had meant it this way but I couldn't understand it, here is my take on this thread.
Development Machine:
Create an ODBC: C13_VSO3Data_FB
Open Database
Create Connection: C13 and make it use C13_VSO3Data_FB as source
Create Remote Views based on the "Connection" C13 (as opposed to what I have done till date)
Users Machine Copy 1:
Install App
On First Run
1) create an ODBC: C13_VSO3Data_FB_12345 (12345 based on the code generated of the pathanme)
2) Open Database
3) DBSetProp() connection C13 to use C13_VSO3Data_FB_12345 as the source
Users Machine Copy 2:
Install App
On First Run
1) create an ODBC: C13_VSO3Data_FB_67890 (67890 based on the code generated of the pathanme)
2) Open Database
3) DBSetProp() connection C13 to use C13_VSO3Data_FB_67890 as the source
I have tested the theory in the VFP IDE yesterday and was successful, hoping to do the same in the app.
There was a positive offshoot also. Supposing a client wants 2 copies of the software as above,
but he wants to share some master data between both the app copies, most probably we can:
Development Machine:
Create an ODBC: C13_VSO3Data_FB_Global
Create an ODBC: C13_VSO3Data_FB_Private
Open Database
Create Connection: C13_Global and make it use C13_VSO3Data_FB_Global as source
Create Connection: C13_Private and make it use C13_VSO3Data_FB_Private as source
Create Master tables Remote Views based on the "Connection" C13_Global
Create Other tables Remote Views based on the "Connection" C13_Private
Users Machine Copy 1:
Install App
On First Run
1) create if not found an ODBC: C13_VSO3Data_FB_Global
2) create an ODBC: C13_VSO3Data_FB_Private_12345
3) Open Database
4) DBSetProp() connection C13_Private to use C13_VSO3Data_FB_Private_12345 as the source
Users Machine Copy 2:
Install App
On First Run
1) create if not found an ODBC: C13_VSO3Data_FB_Global
2) create an ODBC: C13_VSO3Data_FB_Private_67890
3) Open Database
4) DBSetProp() connection C13_Private to use C13_VSO3Data_FB_Private_67890 as the source
Of course there may be practical problems to the above, but my first impression of the theory got me really excited.