>>>>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?
>
>Kenneth,
>
>Don't use the root of c drive for your temp folder. Use a directory.

changed to C:\TEMP

Same problem.

I found somewhere I was resetting the RecordSource to the cursor. I took this out and the references to the columns.

So now I have this:

Form Load Method: Creates blank cursor called CaseSQL
GRID Record Source is set to CaseSQL originally.
GRID columns are set with the appropiate fields from CaseSQL

Now, run system on one machine and comes up fine.
Start on second machine and Grid comes up completely white.

The recordsource is still there (CaseSQL) but the grid is completely blank.

I am confounded. It must be me because I have done this many times before but I am besides myself at to why this now.