Here is a basic model of provisioning shared access to a single SalesPartner 14 SQLite database. In our virtual machine (designed to mimic a Remote Desktop server) we've created two users named 'SalesPartner' and 'Operator'.
The 'SalesPartner' user is considered the primary account holder, in that they use the default rezy.ini from the main Windows folder. The FDConnectionDefs (database connection definitions in C:\spartner\) are notated as pictured.
In the Operator's Documents folder, a SalesPartnerInit.ini file is created to specify the database alias (matching the path in FDConnectionDefs). And their unique Rezy.INI file is specified also.
A copy of the original Rezy.ini file is placed into the path described above, and the second user's tmp path is edited.
Considerations: Both users share the same database file. If there is extensive simultaneous record editing, changes may not post until the open copy is closed. Therefore this design is suitable for a high performance scenario where one user primarily edits the data and the other mostly uses it as a reference. For example, a salesperson with a personal assistant. Or in a team environment where simultaneous data entry happens infrequently.
RSS Feed
