1. Home
  2. Inventory and Item Tracking Software
  3. BACKTRACK
  4. BACKTRACK Error Messages
  5. “The Multi-Part Identifier “USER.USER_NAME” Could Not Be Bound.” When Creating a New Transaction Report – BACKTRACK Error Message

“The Multi-Part Identifier “USER.USER_NAME” Could Not Be Bound.” When Creating a New Transaction Report – BACKTRACK Error Message

Summary

This article explains the BACKTRACK error message “The Multi-Part Identifier “USER.USER_NAME” Could Not Be Bound.” and details how to fix the underlying problem that caused it to appear.

Explanation

This is an SQL error.  It indicates that BACKTRACK is having problems trying to connect to a field USER_NAME in the table USER.  This error may point to problem with the SQL database or a program bug in BACKTRACK.

Solution

If this problem occurs immediately after a database restore, it is likely that the restore failed and it left the database in a non-usable state.  If you can, try restore again.  If BACKTRACK is completely non-functioning, you will have to uninstall and reinstall the software (repair would not work) and perform the restore again.

Restore can be found at:

Main Menu \ Database Maintenance \ Transfer Functions \ Restore

Additional Comments

Error first appeared: Windows 7,8 running BACKTRACK 2012.00.04

Updated on July 28, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support