Thank you for your post, and I apologize for the late reply.
When you log into Terminal Services, it sounds like it is trying to access the original server. The fact that the user can access the file through Open Remote leads me in that direction. Has the IP address changed? Was there any authentication occurring? Was it opening a file that is trying to access the file at a specific IP address? This is what I'm trying to decipher when someone logs into Terminal Services.
If you have already found a solution, please let us know, just in case other users run into the same situation.
"Also, I would love to know how to disect the structure of this DB as I would love to recreate in SQL"
I don't have a copy of Filemaker 7 to test this, but I think it was the first version where you used a relationship graph, similar the the relationships form you can create in MS Access, to create/modify the relationships. See if you have an option called Manage | Database in the file menu. If so, you should be able to pull up an ER diagram that would help you analyze the structure.
If FMP 7 does not have this feature, you could download a trial copy of Filemaker 10 and use it to open a copy of your database file(s). The resulting graph in Manage | Database | Relationships should give you a pretty decent picture of how the database is structured.
I have it working - not fantastically, but working. I had to have the user bypass a lot of the useless login screens and found out that the 4th login is the actual FM instance login.
That being said, I think we are going to just rebuild the entire DB and from scratch in VB.net. This particular program came from someone who threw it together some 5 years ago, it has no support and we can make no significant program changes.
Thank you for your response.
Thanks for the tip. We have a VB.net programmer organizing the structure based off the FM DB. He can throw together the interface and I will work on SQL and hopefully by Spring we have a new DB.
I am by no way dissing FM - it just doesn't fit well into our desired needs and I don't want to have to learn a new application. All of our other in-house programs are VB, Foxpro, or Access.