>I have a project I’m working on at the office. The tables for the project are on a different computer and I’m accessing them using a Set Path To \\NT1\Public\Data. On the weekends I want to bring the project home, so I restore the tables in a local folder at home like C:\VFP\Data. I change my default path and search path in Tools/Options. I remove the tables from my data environment and from the project then add them back in. Then I change my Set Path To C:\VFP\Data. I can’t get VFP to see my new path or tables. Not only won’t it see the path, it also changes my search path back to \\NT1\Public\Data.
>Where is this coming from and how can I do this?
>
>Thanks in advance

Firstly, throw away SET PATH stuff. Then, add code to DE.Beforeopentables event. This code (might be some generic method) will reset Database property for all DE.cursors in run-time, e.g.

Thisform.SetAll('Database',oApp.datapath,'Cursor')

You may keep actual datapath string in local Config.dbf (configuration table), some people prefer Ini file or Win registry.