I have created a application that works fine for single user. The application has a Bill.dbf which contains the name of file and its location on Hard disk.
When the user search for the file its Name & location is instantly displayed on screen .Further When the user click on the location link the file it is opened there and then only . I have used Shell command to open the File for this. For a single user it is working fine.
Now I have been asked to make it multi user so that any one on the network could search from anywhere and could open the file.
For the above purpose I have made a small interface that will have two menus namely Search & Exit. The above interface will be installed at the various network PC
Problem No-1
When I search for Bills from Network PC, The data as contained in Bills.dbf i.e Filename & its location is displayed on Network Screen. However, When I click the same the it didn’t gets opened obviously because the Path saved was E:\Bills\12345.pbf i.e the local path of Server Machine where Bills and the main application is installed.
In other words what I will have to change my location to make it universal for all machines including Server & Network Machine, means something like \\ABC\BILLS\E\12345.PDF instead of E:\BILLS\12345.PDF so that when I click on the link in interface, or server the file should get opened.
Problems No 2:-
Up till now since I was using single user, I was able to PACK and ZAP Records in between the execution of Procedures/program. But Since now I will be under multi network, what is the best way to execute PACK, ZAP etc.
Kindly Give other guidance by your own to have good network application
Harsh