Is "index" the name of the file that you are trying to open or a different file name?
What is different about the "colleague's desk"? Is that the computer from which the file is hosted?
This sounds like you have an external data source reference to a file named Index.Fp7 that is not correctly set up for use from a client machine connecting to a hosted database file. I would open Manage | External Data Sources and check the entrees made there that refer to this file and see what may need to be corrected.
"TEDindex.fp7" is the full name
Network file path: fmnet:/10.0.1.204/TEDIndex
Colleague's desk runs FMP11.0v4 host computer is not my colleague's
Host computer is "10.0.1.204" and they are all in same local network
I selected 'prompt user for username and password' on 'edit data source' and it still gives me same error
TEDindex.fp7 is a FileMaker file, but 'prompt user for username and password' is an ODBC data source option--not the data source option that you should have selected for a FileMaker file. That could easily explain this error message as the error message is telling you that it can't open the file. And ODBC might be configured on your colleague's machine to make this work, but I really see no good reason for using an ODBC link from one FileMaker file to another.
To rephrase my original question:
is "TEDindex.fp7" the exact name that appears in the error message? Is it also the exact name of the file you are opening from Open Remote?
Yes "TEDIndex.fp7" is the exact name appearing on the error message, and It is the exact name of the file I'm trying to open.
I was only able to see the ODBC data on my colleague's machine as I don't have an option to select 'manage' on my computer. Sorry for the confusion
But why use an ODBC reference to a file you have to open directly anyway? That seems a very needless complication to your design.