I know this is a but old-fashioned, but I like to store stuff like that in a local INI file that I read and write to as required. If there is no value in the INI file, use LOCFILE or you can get fancy with ADIR() to find the database and write the INI entry.:
[DataFiles]
SourceDir = F:\myapp\data
You can use the FFC registry class INI reader/writer to maintain it. This way, if your users map drives differently you can cope. After you have confirmed, in code, that the database exists in the right place, you can SET PATH to it.
>I have an application and would like to put the database on a network drive.
>
>What is the best way to tell the application where to find the database? I'm using private data sessions within the
>form.
>
>I have a few ideas that I have read, but would like to here some opinions.
>
>Also, any ideas on how to speed up are welcomed.
>
>Thanks you
>
>Manny
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05