View only information for a specific database
In Advantage database manager one can see all connected users with all their open tabels and files etc for all databases on a server. It would be very handy to limit that to only those connected to a specifik database on the server. Likewise the option to disconnect the users from the server should also support only to disconnect the user from a particular database
Try Using "Ahsay backup" for taking backup as this software gives backup and helps restoring also, I am using this software from long time and really satisfied using this software, So try restoring from this software only, Leaving a link for "Ahsay software" just check: http://www.ahsay.com/jsp/en/home/index.jsp?pageContentKey=ahsay_products_overview
The Remote Server Info view as well as the option of doing that thru sp_ stored procedures is a security nightmare.
To get the current users of the connected database, use:
execute procedure sp_mgGetTableUsers(database())
However, you'll not get the connection handle which you could use to check for open tables etc.