Thank you for your post.
In the "OnSite7" file, it is trying to open the "Int_Session.fp7" file. When you click OK, FileMaker prompts you with an open file dialog, allowing you locate the "Int_Session.fp7" file to open. If you click Cancel, OnSite.fp7 will open, but any relationships you have with the Int_Session file will be broken.
Perhaps the "Int_Session.fp7" file is located in the same folder with OnSite.fp7. Perform a find on your system for Int_Session.fp7 and open the file.
This is due to a messed up External Data Source entry that tells FileMaker where to look to find this file. You'll need to either put the file where this entry specifies or update the external data source entry to specify the new location of this file. Either way, you'll need to open Manage | external Data Sources and look for an entry that refers to this file.
I cannot locate the file anywhere on my system. Is there another location where I can retrieve the file or download the file? Or do I need to reload the application?
If you are unable to locate the Int_Session.fp7 file, then you may want to remove it. To do this, after you open OnSite7, pull down the File menu and select Manage -> Database. Click on the Relationships tab, and you will a reference to the Int_Session.fp7 file. Click on Int_Session.fp7 and delete it. Any reference to this file on your layouts will also be removed.
If you need the file, then contact the person who created the OnSite7 file.
select Manage -> Database. Click on the Relationships tab,
If that works, ignore what I am posting, but there may not be a table occurrence there and it may not be named after the file if it is. (A script can reference a script in the file and a value list can be set up to refer to a value list in the file...)
You might, instead want to try removing any entries in Manage | External Data Sources on a copy of your file and then try opening your file and see what happens. You may now get a different message or a table occurrence over in Manage | database | Relatinships may now appear to be an empty box so you'll have to try it and see what happens.
I've had exactly the same problem with the "Int_Session.fp7" file. It happens when we phase out a PC and install the software on a new PC. The new install of FMP works but the ONSITE link doesn't. I've had to let Shopworks remote access the PC to fix it. I'm really tired of paying them to fix their programing problems. I'm guessing you had to let them fix it also. Any insight as to what they did?
To repeat, use Manage | External Data Sources to check for and update any external data source references to a file with that name.
The answer to the Shopworks / Onsite problem is with the SERVER PERMISSIONS FILE.
The following is copied (with thanks) from the Shopworks site:
"If you installed Shopworks on a workstation and can see the hosted database but not the database files through File “open remote”, it is likely that the server.pem file did not get installed due to security settings on your computer.
The Server.pem is an SSL certificate file that is created when you install FileMaker Pro. It is used to find files for a hosted database. There are steps for both
Mac and PC
Follow the steps below to fix this issue for a PC
download the file “Server_Pem PC file.” Click here to download the Windows file (http://www.shopworkscentral.com/projects/4hryq8o07h) Extract the
file and make sure you are exited out of FileMaker Pro before moving to the next step.
Copy the file “server.pem” into the default directory for you FileMaker Pro installation folder.
*The default location of server.pem is :
C:/Program Files (x86)/Filemaker/Filemaker Pro 10/"
If you go to SHOPWORKS and log in... it is in one of their posted Help File Downloads. Has Pictures and the Download Zip File.