|Subject:||Re: Synchronizing priv tbls with master tbl
|Date:||Tue, 31 Jul 2018 07:46:01 -0400
|From:||"Steven Green" <email@example.com>
you can specify the cfg file to use, on the command line
you should specifically try to lock a record in a multi-user environment..
you should specifically try to post a changed record in a multi-user
Myrtle Beach, South Carolina, USA
Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Peter" wrote in message news:firstname.lastname@example.org...
Did some more research. I found that one of the machines is using
IDAPI.cfg and the other 2 are using IDAPI32.cfg.
Can someone tell me how to force Pdox to use IDAPI32.cfg because when I
eleiminate the IDAPI.cfg it just makes a new one. Thank you.
Local_Machine\Software\Borland\Database Engine\CONFIGFILE01 (changed
from IDAPI.cfg to IDAPI32.cfg).
That seems to have done it, now all 3 machines are running idapi32.
Unfortunately it has not amde a difference :(
On 07/30/2018 11:15 AM, Peter wrote:
> Thanks for the feedback everyone.
> I built the server and got it to be the master browser, tested, same
> inconsistent results. Now I am completely flummoxed.
> It seems to me in a multi-user environment that if user_1 is viewing a
> table and user_2 changes a field that user_1 should see the field contents
> updated within the set refresh rate. I thought this would apply equally
> whether viewing a table displayed or via form.
> Barring any other ideas I guess I'll have to come up with a different
> strategy for syncing.
> On 07/28/2018 06:31 AM, Steven Green wrote:
>> 1) always have a dedicated server, if possible.. a shared server is using
>> half the cycles to be a server, half the cycles to be a workstation.. and
>> if you lock up or crash the "workstation", you've crashed your server
>> 2) in your example / test, you are depending on paradox to control and
>> protect a multi-user app.. up to a point, it does.. but if your app
>> posts, locks, error traps, etc., then YOU control it
>> Steven Green
>> Myrtle Beach, South Carolina, USA
>> Collectibles and Memorabilia
>> Vintage Lego Sets and Parts
>> - and Paradox support, too
>> "Peter" wrote in message news:email@example.com...
>> I checked all the machines, 1 of the workstations had Enable Offline
>> Files checked so I unchecked it.
>> I make the change in a field and simply move to the next record (no
>> code). I do this on the table, I also tried it on a test form.
>> I also checked the "Folder Options" in W-Explorer and made sure the
>> following were checked on all 3 machines
>> Automatically search for network folders and printers
>> Use simple file sharing
>> I've spent over 10hrs chasing this demon and am thinking the best thing
>> is to build a dedicated server.
>> On 07/27/2018 07:05 AM, modridirkac wrote:
>>> You do PostRecord and/or UnlockRecord after changing field, do you (or
>>> just move to next line)?
>>> You have checked "No files or progarms from the shared folder are
>>> available offline" in folder's sharing properties on "server"?