>Currently, our users' Windows logons activate scripts which map various network drives for their access. Some of these drives contain VFP data files which will be needed by various VFP applications. We would like to remove such automatic mapping & instead on-the-fly, from within VFP applications, provide access to specific network folders containing VFP tables. This would most likely require passing special username/password/domain information as part of accessing the VFP tables. Can this be done? If so, is it advisable or efficient?
>
>Thanks,
>Randy W.

Hi There

In order to function smooth, VFP need FULL access to directory containing VFP data.

As for mapping of drives, this can be completely avoided if application is equiped with proper functionality to open distinct dbc location(s) instead of requiring mapped drive.

If you wish, I can send you solution I use for years now, enforcing database paths via one line of code added in each form's DE.BeforeOpenTables method.

But is only applicable for tables within database. You will hv to amend it for free tables if used.

Rgds++