How do i make a .prg file in Foxpro as multiuser or client server mode/

I have an application running under Foxpro.It is created on stand alone pc having different modules.
What is required is create the Application as multiuser on client server achitecture and i want that some .prg files should not work for some users and some should work for any kind of users.

Kinldy Help
Who is Participating?
CaptainCyrilConnect With a Mentor Founder, Software Engineer, Data ScientistCommented:
In the menu that calls these prg files, you make certain links visible for the users and hidden for others. Or you can make it visible and not visible.

You have to create certain flags in the user profile when they log in.

If you don't have a user profile and you wish to control it my machine, you need to read SYS(0) to determine which machine has the program run and hard code it.
Gary2SevenConnect With a Mentor Commented:
FoxPro is not a client/server development tool.

You can however use it as a front end to link to an SQL server backend. If you want to create user roles to control menu and data access you will need to write them in code. There are no inbuilt tools for this, however it is quite easy to code either using menu builder or by building a menu from code.

If developing for multi user and not using an SQL backend you will need to write file locking routines and ensure data is opened in multi user mode.
searchsanjaysharmaAuthor Commented:
Foxpro is not a client server development tool. Thats why the question is there. Secondly we have spent friend 2 years for development and we dont migrate to to new technology.
As it will waste lot of time. So we are in lloking for the optimized solution.Like sharing the software across the machines and then enabling or disabling the menus.
Never miss a deadline with

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

CaptainCyrilConnect With a Mentor Founder, Software Engineer, Data ScientistCommented:
If the files are indexed properly you will still get excellent performance.

You have to decide whether to do access by user log in or by machine and then it's easy from there on. It will be just coding.
pcelbaConnect With a Mentor Commented:
Before you move the software to a network environment you should read something about concurrent access to data.

Some basics are here:
Useful hints:
This article is a little bit outdated but still valid:
A question about multiuser environment was answered here many times, one example:
You could also read the discussion on the same topis:

I would also recommend to read some book about VFP from Hentzenwerke (
AndrewJenConnect With a Mentor Commented:
Interesting how Microsoft duplicates similar topics...
My link ( was for VFP 8
Above link from Andrew is for VFP 7

One more exists for VFP 9.2: and it seems to be the most current.

In addition to above links Microsoft is publishing exactly same topic "for .NET 3.5":

Is this the goal of HTML?
CaptainCyrilFounder, Software Engineer, Data ScientistCommented:
There was a lost pilot in a chopper in foggy Seattle. He saw a bunch of guys working in an office on high floor of a building. They turned out to be MS developers. He wrote to them on a paper asking where he was and signaled in his hands that he was lost. They wrote on a paper that he was in a chopper!
searchsanjaysharmaAuthor Commented:
searchsanjaysharmaAuthor Commented:
All Courses

From novice to tech pro — start learning today.