> My problem with one user in particular is the "phantom user", which > prevented them from reloading their data base in single user mode and I > have maintained is a result of one or more users exiting RBase improperly.
It sounds more like someone exiting Terminal Server Client improperly -- just disconnecting the seesion without closing down R:Base at all. It's easy to do, and it's actually legimate if you are just temporarily dropping the session and want to resume it later. > Emmitt pointed out that if the data base is "stuck" open, you can normally > go to My Computer, Manage, Shared Folders, and usually close the open data > base. I haven't seen this, but I've been told that the data base can be > "locked open" and then the server must be restarted. Emmitt's right. You can always "kill" the connections to the active database this way, no server restart required. Then, the next use in to R:Base should "detect" that they are the only user and clear all the locks inside the database. -- Larry
