They are gathering data to populate an Excel spreadsheet. I've not seen the template that they are using, so I'm not sure of the specifics, all I've done at this point is ask my client what's going on. He says that when the Excel document loads, it auto refreshes the data thru the ODBC connection, but never gets to the point of
getting any data. Apparently it's making the connection, but thinks the .DCT file is missing or corrupted.
Since they apparently have the correct Novell rights, do you think it could be something with the ODBC driver?
>I have this exact same scenario on our Novell server and it works as advertised with only RF Novell rights. Something else is causing a Write. There is nothing like a Foxuser resource file being pointed to in that directory is there?
>
>At what point do they get the error? Have they opened a remote view and retrieved data first, then get an error after they do something else? Or do they get an error immediately upon the query?
>
>>Larry, Mark,
>>
>>Thanks for the help, guys. I thought we had it solved ... I called my client to tell them the good news. < g > They said that it still does
not work with
Read and
File Scan ... but as soon as you add
Write then everything is fine.
>>
>>Any other ideas?
>>
>>
>>
>>>You got it. The minimum Novell rights for ReadOnly for VFP tables have to be
Read and
File Scan.
>>>
>>>>WAG, but did the powers that be also take away the ability to search a directory. In NW 3.X I believe the attribute was S or F (file scan). The might stop the ODBC connection from working.