Is Med.db located in your current working directory? If not, you need to use a path.

When I Unload an application using Server Administration, it works fine. So, I believe, it is not other client using it. I have tried directory and even the full path but still it is not working.

I tried the following for so far.

UnloadApplication ("Med.db")
UnLoadApplication ("Data\Med.db")
UnloadApplication ("C:\Sesame2\Data\Med.db")

var vApplication as String = "Data\Med.db"

UnLoadApplication (vApplication)

                         All at once!!!

I cannot get the application to Unload even if I hard-code the command.

There are no clients connected to begin with. That is connected 0 of 4.  Several applications are loaded in the server.

I connect one Sesame Client with small application that has command button to Unload one of the loaded application, namely consult.db

UnloadApplication ("C:\Sesame2\data\consult.db")

or

UnloadApplication ("Consult.db")

or

UnloadApplication ("Data\consult.db")

Application is still loaded in the server. Obviously nobody is currently using it because only one Client is connected with the small application made specifically to unload the application.

What am I doing wrong?

Thanks Mark for looking into this. I also looked at it further. Whenever my application freezes and I have to use hard re-boot or during power failure or system crash or undesirable interruption, there are 5 files that get locked including my main application namely Medical.db.  Other 4 files are Doctor.db, Consult.db, Med.db and Diagnosis.db. Rest of the files numbering to about 12-15 do not get locked but from them xloopups done regularly and they are loaded in server. These files can be successfully unloaded using sbasic command.

It is only those five files that invariably gets locked up on system crash, that I cannot unload using the sbasic command. Rest of them I can unload with the sbasic command. But then I seldom need to unlock those files that do not get locked!!

I understand the main database will get locked up on system crash. But why only those 4 external database  locks up and not the others. Why those 4 databases do not respond to sbasic Unloadapplication ( ) command? What should I do in my coding so, these 4 applications behave like the other external databases?

Thanks you for your help.

The SBasic command UnloadApplication can't unload applications that have been touched by a "human" client (meaning loaded into the client's interface) and remains loaded because it is also touched by a "X" command, or have been touched by the XResultSet SBasic commands (which act like a "human" client). To unload application in either of these cases, use the administrative interface to ensure security and that that application is not actually in use by a human or "human-like" client.