Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-User DBC setup
Message
From
25/11/2006 21:41:28
 
 
To
25/11/2006 13:08:20
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01172353
Message ID:
01172444
Views:
12
Mike,

From my testing, the DBC stores a relative path to the tables. However, if the folder the DBC is in, is a root folder, it will store a full path to the data, including the drive letter.

I've been trying to find a way around this for awhile, without any solution.

>>Hello all,
>>
>>I have been reading as much as possible in various threads on the dos and don'ts of VFP multiuser setup.
>>
>>1) Don't share the .exe over the network. I understand this.
>>2) Don't share the .dbc over the network. Again, I understand this, but I need some technical help here. As I understand it :
>> a) the dbc has a fixed path to where each dbf is located.
>> b) the dbf has a fixed path to what dbc it belongs to.
>>
>>So with A and B said, how do you implement a multi-user setup where each user has their own dbc and executable?
>
>I believe that if the DBC and the tables are kept together during development, the DBC will not store full paths to the tables. This means your exe can SET PATH to the folder containing the tables and the folder containing the exe and DBC and VFP will handle it.
>
>I can't prove it right now. Please give it a try.
>
>HTH

(On an infant's shirt): Already smarter than Bush
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform