>>>>>>Last week I posted a question concerning how to let my forms know where the data is after it has been moved. Dave told me to use VALIDATE DATABASE RECOVER. This worked for most of my immediate problems, but some of my forms still refuse to recognize the new table locations. I have been able to fix most of my problems by rebuilding views and reloading dataenvironments, but some forms are still confused. To make things worse, they only refuse to load SOMETIMES. What is going on? My cursors (DE) show the right path in the database property. There has got to be a better way to do this. What is the correct procedure for moving data from the the test location to the server? Will I have all this trouble next time? I have heard somebody talking about their app reading all of its datasources from an .ini file. How is this done, and is it done at the project level, or the form level? Is it necessary to rebuild all views, and dataenvironments after moving my database?
>>>>>
>>>>>sounds like the forms have the directory location hard-coded somewhere...
>>>>
>>>>But Where???? I have looked everywhere that I know to look. How can I avoid this mess in the future? Thanks for taking the time to help me. This has got me completely flustered. I have rebuilt nearly the entire dbc trying to figure out how to validate these tables.
>>>>
>>>>Erik
>>>
>>>When form loads unsuccessfully VFP generates a message saying what record in scx file contains problem. Open scx file manually, go to the record and probably you will see hint over there.
>>
>>Thanks Edward. This has given me more information about the problem, but I am still unsure how to fix it. Apparently the tables in the views won't load. When I go to the view, it will not open saying 'object (mytable) not found'. It then gives a normal empty view builder template. It allows me to choose the tables from the list build the view, but when I try to save, it opens another open tables dialog box. hiiting cancel gives file 'mytable.dbf' does not exist. Choosing the table again with the dialog gives 'Index file does not match the table. Delete index and re-create.' So I do it. But trying to create the view again afterward gives the same error. What the heck is going on?
>
>I really have no idea. When I worked on my first VFP project I got similar problems moving data around the network. Firstly, I opened scx files, and when got tired I wrote common method to reset datapaths in BeforeOpenTables event. After this I've never got those problems again.

New clues (or confusion?) for those of you whom my troubles haven't put to sleep yet :-). After logging in this morning, my entire application works flawlessly. But before I left yesterday, only about 5-6 of 30 forms would even load. I am just waiting for everything to go on the blink again, and I will be in the same position as yesterday. I am getting close to calling MS on this one, if you have any clues to save me from this fate, please advise. Thanks.

Erik