When my installation is run as an upgrade I inform the user to ensure that all Pervasive connections are close on all of the clients, however, that warning is often ignored and our DDF files are not always being replaced because a client has them open on our server. How can I detect if the server engine has files open?

You can use the monitor to see if any files are open.

Jose

Sorry, I should have been more specific. I'm aware of the monitor program. I'm looking for a way to detect open Pervasive files inside the Installshield script or at least via a Visual Basic application. I could write an app that attempts to delete the DDF files and trap for a permission denied error but I would rather be able to detect the open file(s) the way the monitor program does. I'm wondering if this is done with DTO? It might even be better if I could delete all active users the way the monitor program does. Thanks for the reply.

 You can use DTO or DTI to detect open files and then disconnect the users.  Because DTO is a COM object, you can call it from InstallScript or VB.  There used to be a Disconnect Users sample on the Component Zone (http://www.pervasive.com/componentzone). 

We also have a free tool called KillUser that can be used.  Get a copy from our web site at www.goldstarsoftware.com/tools.asp.

The downside with DTI/DTO applications like these is that you need to have the server name, an Admin username, and a password.

Thanks, I'll check that out.