It is possible to add Vendor Misc Compliance, Job Misc Compliance, Lien Waiver, and Certified Report records using ODBC. However, it is not possible to update the Last ID field for these records in the processing controls record using ODBC.
When you attempt to create a new record in the software, it will attempt to assign the next ID after the Last ID to the new record. If that ID was already used by a record added using ODBC, it will see that the ID already exists and the error will occur.
Note: If the error only occurs on one workstation and does not occur on other workstations in the same database, refer to article ID 80807 DocLink: Error: "Duplicate key value during insert of the [record name] record..." (corrupt Windows user profile)