>Dear Experts
>
>I am using following methods:
>
>1) I use Database Container.
>2) I do not use free tables.
That helps, but it doesn't really matter much for networking.
>3) I add all necessary dbf’s in DataEnvironment.
>4) Do nothing on the Load Evnet.
Either the Load() Event or the DataEnvironment is the correct place to open tables.
>5) For Indexing I use Init Envet as
> Select Table1
> Index on sno to XYZ
This will cause great problems for networking. Use permanent indexes (with TAG instead of TO), and don't index every time you open the form.
>6) I do not adopt following method anywhere to load dbf’s
> use table1 in 0
It is safest to open tables IN 0.
Also, every form should have its private dataenvironment.
>What should I do to convert my recent projects for Networking.
Also, you need to do a SET EXCLUSIVE OFF, to be able to network.
To test if your program works over the network, you can simply open two copies of the program on the same machine, and see if you get any problems. Most problems related to the network are related two two users trying to use the same resource (table, index, etc.)
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)