The first time Dimensions or Importer is installed on a PC, the user must log in using their full user name rather than just their user ID. Use the More button on the login screen:
Click More >>.
Enter the User Name.
Enter the Password.
Clear the Data Link field.
Select the ODBC Data Link.
Clear the Database field.
Select the Database.
Click Logon.
If you see 'Unable to log in to the Server, either your User name or Password is incorrect or you do not have permission to login. Please note that the password is case sensitive.', check the credentials and try again. If the issue persists, you can use Datachecker to restore the user. This is rare. ⚠️ Warning: Changes made with Datachecker cannot be reversed. Take a full database backup before proceeding. To restore a user:
Log in to the affected database in Datachecker using the SA account.
Click the Upgrade data for ACCESS ACCOUNTS tab at the top.
Click Generate Users from Accounts Data.
Read the message carefully and take a screenshot showing all affected users. Affected users' passwords are temporarily changed to the first 10 characters of their name — for example, John Smith's password becomes 'JohnSmith', and Samantha Johnson's becomes 'SamanthaJo'. This applies to non-Windows-authenticated users only.
Ask all affected users to log in to Dimensions and change their password.
Alternatively, edit the user's details, then make the user inactive and recreate them with the same details. Editing before making inactive prevents Dimensions from flagging the account as a duplicate.