>You didn't say what mechanism you were using to access the data, but I suspect >that the answer is the same regardless: >You need to make sure that the remote drive has read/write rights for the >IUSR_ account. This is the account that IIS uses when accessing data as a >result of a request. THe reason you are able to open the connection in VFP, is >because you are opening it as a different user. HTH.
Erik, I tried this, to no avail. We are using ASP to access the data via the ODBC link. I checked the permissions on the local drive (where the data still works), and it is set to "Everyone - Full Control" (no IUSR account). This was the same for the remote drive, and I even adf\ded the IUSR account and still get the 'Cannot open file..." error. More details on that: The error occurs on the lines in my ASP pages where I am setting up the connection thusly:
Conn.Open Session("DataConn_ConnectionString")
Where the session variable points to the ODBC DSN.
Anyway, thanks for your help...anyone else have ideas on what is going wrong here? I am going to check out the WestWinds site per Erik's advice and see what I can find out.