>>This one is new to me...
>>
>>I have a form which uses a grid whose record source is a cursor. I gave each column in the grid a descriptive name. When the record source changes, I zap the cursor, then append in the new records.
>>
>>Works pretty as you please, records get displayed, column control sources stay bound....when only one user is accessing the system.
>>
>>If a second user tries to open the form from another machine while someone is already using the system, the grid comes up blank as its record source was removed and restored. I get an error if I reference the descriptive column name (error 1925, Unknown Member) as it reverts back to the default (column1, column2, etc...)
>>
>>I have never seen this in previous applications.
>>
>>Any ideas out there?
>>
>>TIA
>
>How is the TEMP folder is configured for the app? It should be set up to be a local folder. Check your config.fpw for the relevant setting.


Hi Nomi,

Sorry for the delay in getting back but I only now was able to test this. I setup the TMPFILES to point to c:\ in the Config.fpw file. When run on different machines they both get the correct temp file (check with sys(2023).

But I am still getting that strange behavoir. The first instance of the system retains the column names but the second one still reverts back to Column1, Column2, etc......

This is an annoying problem. I would hate to have to go back renaming all the columns to their default as it gets confusing with a 9 column grid.

Any other ideas out there?