Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How reference data on remote server client/server app
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01016248
Message ID:
01016287
Views:
27
>I'm trying to write an app for a multi-use environment with apps and data stored on a server and clients accessing that data. Each machine has copy of program.
>How do I point client app to server where data is located?
>I'm using cursor adapters for data access with native fp data.
>Thanks.

Marcel,

I have exactly the same architecture as yours in place for our multiuser VFP Database app.

What we do is to keep a local(where the program is) preference file(table) which stores the user's preferences as well as the location of your the database. So the first thing the program does is to find the database and load(open) it, if not found, give the user a GetDir() or GetFile() window to locate the database folder or the database then save it in the local preference file for future use.

HTH
Dawa Tsering


"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."

- Ephesians 4:29-30 NIV

Dare to Question -- Care to Answer

Time is like water in a sponge, as long as you are willing you can always squeeze some.

--Lu Xun, Father of Modern Chinese Literature

Previous
Next
Reply
Map
View

Click here to load this message in the networking platform