You will get that message if Sesame Server still has the application loaded when you try to reconcile. You can verify this by looking on the Sesame Server window in the field that says "Open Applications:".

First thing you want to do is open a Sesame Client
Open your DB file
Click the blue save button in the Upper Left hand Corner
Click File->Close
Click File->Server Administration
Log in
Click Notify All Clients
Click Stop this Server
Verify that Sesame Server has shut down
Re-start Sesame Server
Open Sdesigner
Open your DSR file
Reconcile the changes to the DB file

-Ray

What caused it? Without being there I have no way to know. It can happen if a client computer is disconnected from the server computer without closing Sesame first. The Application that the client had open will remain loaded on the server computer. Reconciling will produce an error that the file is in use. Once the file is unlocked, Reconcile will appear to work but the changes will not be seen when the DB file is loaded from a Sesame Client. This is because the Reconcile changed the files on the Hard Drive while the Server is using the files in Memory. This leads to a mis-match between what is in Memory and what is on the Hard Drive. Changing a record will write that change out to the Hard Drive in the structure that the Server knows, which may differ from the new structure that the forced reconcile gave the DB file. This causes the files on the Hard Drive to be part of the original structure and part of the forced structure from the reconcile. Upon shutting down the server, the DB file may or may not load depending on the changes that were made in the design from the reconcile and the changes made in the Sesame Client.

This is why before I had you shut down the Server, I had you click that Save button. That Save button does a complete save of the Application that is in memory out to the Hard Drive. It is not needed in normal operation but is needed in this case, when a reconcile is forced upon an open application.

If you are making Design changes to an application, that is being used Client/Server, you should have access to the Server computer. You do not need to be in the same room as it at all times, you just have to be able to walk over to it and see it's screen. The Main reason is so you can see if the application you wish to reconcile is loaded on the Sesame Server. If it is, then the Sesame Server will most likely need to be shut down before you can Reconcile. Another big reason is so you can make a backup before you reconcile. Always make a backup, if for no other reason than the fact that you never know when the power may go out.

-Ray