Troubleshooting Excel and BarTender

This article walks you through the most common errors when using Microsoft Excel. Common Error Messages Here's a list of common error when using Excel. You can use this list to jump to particular topics or just work through the troubleshooter. Record Set: database name encountered a Connection...

Error message 3602: No items printed because zero copies were requested from the database file

Symptom  When trying to preview or print a template, Error message 3602 appears:   Fix/Answer  This error message is a bit misleading as it has nothing to do with the print quantity or number of copies per serial number. Instead this error message has to do with a conditional print statement on ...

Record Set Error

Symptom  When opening up a label, you receive a Record Set error similar to this: Fix/Answer This error means that the database file has been moved, deleted, or is otherwise no longer at the location BarTender believes it to be. You'll need to manually correct the error. Open up the Database Set...

Error message 3757: Reference to a nonexistent field

Symptom  When trying to print a BarTender document, the user receives Error Message 3757 "The following places reference a nonexistent field" This message may be followed by Error Message 3201 "Database field not found"   Fix/Answer  The error message will tell you the locati...

Oracle BarTender Database Connection Slow Querying Records

Symptom BarTender using an Oracle ODBC database connection is slow querying and displaying records in BarTender database connection setup and when printing. It is querying from a view containing over 600,000 records. Environment BarTender v10.1 SR4 Oracle v12 ODBC driver Fix/Answer Uncheck the ...

My number is being formatted into scientific notation! How do I fix it in Excel and then BarTender?

Question  I'm pulling data from Excel onto my label, but every time I do, it comes out in scientific notation. How do I fix this? Answer With long numbers from an Excel database, sometimes the label will come out like this in scientific notation: This is happening because Excel is truncating the...

Error message 3238: Too many fields defined

Symptom  When attempting to connect an Excel database, you receive the error 3238: Too many fields defined: Environment BarTender and Excel Fix/Answer  There are too many fields defined in the excel document for the database driver to handle. This can happen if you added more columns than you ar...

BarTender Not Reading All Desired Data From Excel Cell

Symptom I have a cell within Excel that has a lot of written data in it. However, not all of it is showing up when I connect it to BarTender. It seems like the data is cut off in a multi-line text object. What is happening? Environment BarTender 2016, Microsoft Excel Fix/Answer Most likely, the i...

Message #6239: The Select Records dialog cannot be shown

Symptom You get the following error message in BarTender: BarTender: Error Message 6239 The select Records dialog cannot be shown due to the following: Environment BarTender Database connection Fix This message typically happens when BarTender can't properly connect to the database that y...

View Database Size under Administration Console pops up empty

Symptom  The View Database Size administrative task under Administration Console pops up empty, or doesn't pop up the first time you click on it. Environment  BarTender v2016 Fix/Answer  The Windows or SQL Server account you've used to connect to the BarTender system database lacks the "View...

BarTender reading additional whitespace from database field

Symptom Text and barocde objects enlarged compared to previous version of BarTender 2016 due to extra whitespace. Environment  BT 2016 Fix/Answer Set a data source transform in the object properties->transforms->truncation->trim spaces on left/right. More Information (optional) Acco...

Error connecting database with Progress ODBC

Symptom Error connecting database with Progress ODBC Environment BarTender v2016 32-bits Progress OpenEdge 10.2B Driver Fix/Answer The problem is that the Progress ODBC DSN configuration dialog does not provide an option to save the password needed for the connection. Thus, the connection fails. ...

Message #6670 Failed to connect to database

Symptom When using BarTender with an attached Excel Spreadsheet, you get: Error Message #6670 Failed to connect to database: unexpected error from database driver Environment BarTender 10.1 and BarTender 2016 Microsfot Excel Fix The most common cause of this problem is that you do not have the Mi...

BarTender: Error Message #3239 (0x80040E10)

Symptom BarTender: Error Message #3239 OLE DB has encountered error 0x80040E10: Environment BarTender 10.1, 2016 Fix/Answer Error 0x80040E10 states the following: "No value given for one or more required parameters." Chances are, there was a change in the database that the user did not...

Message #6241: A connection to the database could not be made

Symptom You receive one of the following messages when working with BarTender and Microsoft Excel: Message 6241 A connection to the database could not be made due to the following: External table is not in the expected format. Record Set Error Message: The 'Microsoft.ACE.OLEDB.12.0' Provider is N...

Message 3201: Database field not found

Symptom You get the following error message in BarTender: Message 3201 An object on the template was set to read in the field "<field name>". However, this field was not found. Proceed with unknown fields as blank strings? Environment BarTender Designer Fix/Answer Each object in ...

Error 6670 after installing Windows Updates

This article refers to a specific problem that happened in the fall of 2017. We've left this article here for historic reasons, but if you're currently experiencing Message 6670, it's unlikely that this article will help you. You should see this article instead: Error 6670 when using Microsoft Ex...

Error 3600: Template does not reference any database fields

Symptom When trying to print you receive: Error Message 3600: The print job has been aborted because the template does not reference any database fields. Environment BarTender Designer Fix Option 1: Link at least one field on the template to a the database If you do need to use the database, you...