Simultaneous Processing in Server 8.5

[Flappy]

I am swimming deeper into the Server 8.5 waters and am having some encouraging results. My solution is hosted on server 8.5 in my production facility on a very zippy Windows XP machine. The only real problem I am having is that when inputting orders on my remote client at my retail store, it is a little sluggish. My thought is to have a local file at the store with which the rep can do the order input, then import the records to the main table at the host. My question is how would Server react if for instance someone on the network at the production facility was inputting an order, and the rep at the store was to initiate the import into the same table? Would the store be locked out until the current record is committed; would it fail entirely ? Am I smokin too much fairy dust ?

[normanicus]

Don't use import for this. You will get problems.

Try these:

1. Get a faster connection in the remote office.

2. Set up a cheap Windows box in the main office, install FM on it and control this with Remote Desktop (RDP) from the remote office. This works OK even with slow ADSL.

3. Use the separation model. This could be a lot of work depending on the complexity of your solution.

4. You could try SyncDek: http://syncdek.com/. I tried but didn't get on with it.

There are yet more possibilities,

Norman

[Flappy]

Hi-

Thank you for the reply. For my curiosity (and education), what types of problems might I expect with the import method ? I have explored the other options you mentioned (though I am still working on a faster connection than my DSL in the remote office) My volume of use is not that great, with lots of down time during the day, so I thought I could make use of that time.