There are two resolutions for the situation:
1. Increase the licensed allowable User limit
If more Users are required VersaDev's Sales Team can be contacted to arrange for an updated license key to accommodate the extra Users.
2. Archive exisitng active Users that no longer need access
To solve this without adding a new license key the surplus User account(s) will have to be archived in the database. Please note that this procedure needs to be performed by a Database Administrator (DBA) as the User(s) will need to be archived directly in the database by changing their archived status. The DBA will have to replace the *UserID* value below with the actual ID of the User(s) to be archived.
NOTE: VersaDev takes no responsibility for any data corruption or loss incurred, be sure to take extra care not to remove or change any data by mistake when running queries directly on the database, we recommend performing a backup and implementing on a test environment before performing on production.
1. Find the UserID of all active Users:
SELECT UserID, Firstname + ' ' + Lastname AS [Name], Email
FROM tbl_Users
WHERE Archived = 0
2. Update the archived status:
UPDATE tbl_Users
SET Archived = 1
WHERE UserID = *UserID*