Errors trying to Sort Records with Upgraded FM Database
I work for a non-profit company and this year we upgraded our filemaker server to 9 and filemaker pro for clients to 7. We have a small office with a mac network. We run the server 9 on our mac xserve and the filemaker pro 7 on the client machines for remote access. Ever since upgrading, our database has had some weird errors. Jenny
Every time you open the database and click "Sort Records," it does the following before sorting:
-A window pops up and says "50 States" could not be opened. (Not Found), and you have to click "OK"
-Then the "Open File" window pops up and says "50 States" could not be found. Please locate the file or click cancel to cancel any further requests for this file. And you have to click cancel.
-A window pops up and says "CCAF Master Database.fp7" could not be opened. Either the host is not available or the file is not available on that host." (This isn't even the name of our database) You have to click "OK"
-Then the "Open File" window pops up and you have to click cancel.
-This is when you finally get to the "Sort Records" window.
The next time you sort this doesn't happen unless you have closed and reopened the database, then you have to go through all that again. Is this an issue with some kind of missing field, or reference document that maybe didn't get transfered properly? If so why would this not have any issues on the older filemaker server database that we have been using for years? We have also noticed a major loss in speed when you open the database remotely. If someone can clue me in on how to fix this, it would be very much appreciated.