We just installed 3 1240AG's w/ Airnet 1728 omni-directional antenna's. Set all 3 to same SSID and WEP pwd. Each have a unique static IP address. Approx. 50 - 70 feet apart on same floor of office bldg. What other settings will optimize seamless, fast roaming (no drops etc...).
All settings, except for those mentioned above were left at factory default.
It's a must do.
When a client roams away from an Access Point, it obviously has to look for another AP to roam to. In situations where APs are all on the same channel, this usually leads to a situation where the client will completely drop its connection before associating to the next AP.
When differnet channels are used, the client is able to make a roaming decision much sooner, and the whole process becomes much smoother and more transparent to the user.
Of course, wireless isn't a perfect medium, so i'd still suggest that your database employs some reliable locking mechanisms to help prevent corruption.
Change the channels as suggested and let us know how you get on; I think you'll see a big improvement.