Our ERP system is a hybrid. The actual data is SQL, but the tables which contain user information, profiles, rights, security, etc is in Visual FoxPro.
I need to get exclusive access to the VFP database. I remove everyone from the system using the program itself, and it indicates everyone is out of the system. I get the following response to the following code:
set excl on
open data l:\M2MDATA\Util\util.dbc excl
The response I get is : File Access is Denied. I went into server manager and nobody has any files open in our VFP directory.
Is there a command in VFP that will allow me to determine who/what has the file open and/or a way to kill any sessions within FoxPro that do?
I tried googling it but had no luck.