Jump to content
Sandy

Bartender: Error Message #3226 & #6670

Recommended Posts

Sandy

On two different machines, I am attempting to print a label using the same excel database.  The label and Excel files are in the same shared directory.  I am able to open the spreadhseet directly from either machine and the bartender label (btw) file from either machine.

 

One machine, I have no problem.  I could open the btw file and print the label using either xls or xlsx file as the database source.

 

However, the second machine - I can open the label, but when I attempt to print a label, it prompts correctly for the data required, but then I got the Error Message #6670.  I created a brand new xls file by copying and pasting the data from the original spreadsheet as was recommended on one forum, but still, I cannot print the label.  

 

I then tried to login to the second machine using my credentials (full access to everything) to and I get the same results EXCEPT I get Error Message #3226.

 

Does anybody have any ideas?

 

 

Share this post


Link to post
Share on other sites
Ian C - BarTender ninja @ Seagull

This is a limitation of Excel I'm afraid.  Excel uses exclusive file locking, meaning that only one application/computer can connect to it at any one time.  I suggest that you use a proper database instead of Excel for more sophisticated record level locking and access types.

Share this post


Link to post
Share on other sites
John Halstead

I've connected my Labels to an Access database and get the same problem Error #6670. I can open the label and get to the data prompt but in comes up with the error after you have entered the data. So basically, if you connect to your data source directly, you get one error, and if you connect to the same data source via access (as suggested in various posts), you get another....

Share this post


Link to post
Share on other sites
Domingo R - Seagull Support

John,

 

What Edition, Version and Build of BarTender is in use?

 

What Windows Version and Service Pack?

 

Could you attach a screenshot of the error messages you get in BarTender.

 

If this same problem is reported in a different post, please send me a link to this post.

Share this post


Link to post
Share on other sites
DieselOx

This is a limitation of Excel I'm afraid.  Excel uses exclusive file locking, meaning that only one application/computer can connect to it at any one time.  I suggest that you use a proper database instead of Excel for more sophisticated record level locking and access types.

BarTender appears to lock Excel only while it is actually quereing for data. Once it's done (a second or 2 usually), it becomes available again. We use it in a production environment with multiple stations accessing the DB. We also use an Oracle DB for some stations, but both Excel and Oracle have their own drawbacks. Our problems with Oracle are only due to our Oracle client, which is massively cumbersome.

 

Most likely the problem the OP has is with OLE DB network access driver compatability.  We are tracking down the same error.  Many machines on our network can access an Excel file, but one new one cannont (all versions of all software the same: Excel 2013, BarTender 9.4 SP3, Windows 7).

 

If we find anything I'll post back.

Share this post


Link to post
Share on other sites
Domingo R - Seagull Support

DieselOx,

 

Excel can make use of two database drivers: Jet OLE DB et ACE.OLEDB. Please check and make sure that when you connect to the database using OLE DB that the same driver is being used at all computers. You could even connect to the Excel spreadsheet using a "General OLE DB Provider" in BarTender's database connection setup dialog and then search to see what type of OLE DB provider for Excel you can use at the different computers.

 

Sometimes, it also helps to install the latest Office System Driver connectivity Components:

http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

 

Try as well to install the latest Access database engine redistributable:

http://www.microsoft.com/en-us/download/details.aspx?id=13255

  • Like 1

Share this post


Link to post
Share on other sites
DieselOx

DieselOx,

 

Excel can make use of two database drivers: Jet OLE DB et ACE.OLEDB. Please check and make sure that when you connect to the database using OLE DB that the same driver is being used at all computers. You could even connect to the Excel spreadsheet using a "General OLE DB Provider" in BarTender's database connection setup dialog and then search to see what type of OLE DB provider for Excel you can use at the different computers.

 

Sometimes, it also helps to install the latest Office System Driver connectivity Components:

http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

 

Try as well to install the latest Access database engine redistributable:

http://www.microsoft.com/en-us/download/details.aspx?id=13255

 

 

The second link had the drivers we need. Just now had to roll out a new system on another computer, needed to install AccessDatabaseEngine.exe (not the 64-bit choice). Our problem crops up because we are using a mix of 32-bit and 64-bit Office on a mix of 32 and 64-bit computers.  64-bit computers don't automatically install drivers for files created on 32-bit office. So I create an Excel DB on my 32-bit Office, and the newer production computer running 64-bit Office lacks the correct drivers.

 

This fixes it every time. Thanks.

 

Chris

Share this post


Link to post
Share on other sites
Domingo R - Seagull Support

OK, thanks for the update!

Share this post


Link to post
Share on other sites
erik44

On starting MS Excel you may face error message as shown below;

·        
Corrupted shortcut to the Excel program

·        
Problematic file in Excel startup folder or alternate startup file location

·        
Corrupted Excel toolbar file (*.xlb) or Excel .pip file

·        
Corrupted add-ins

·        
Incorrect version of a core Microsoft Office file

·        
Corruption in the registry keys

·        
Other problems when opening Excel files

 

To fix any of the issue it’s always suggested to check whether all updates are
installed or not. If not then install them as early as possible. If the error
is not yet gone then try manual methods listed beneath;

 

Method 1: Fix the
shortcut to the Excel program

 

1. Click Start,
point to Search, and then
click For Files or Folders.

 

2. In the Search for files or folders named box,
type Excel.exe.

 

3. In the Look in list, click My
Computer
, and then click Search Now.

 

4. After the Excel.exe file is found, double-click
the file to start Microsoft Excel.

Note: The
typical location of the Excel.exe file depends on what version you have
installed.

 

Microsoft Office Excel
2003

 

C:\Program Files\Microsoft
Office\Office11

 

Microsoft Excel 2002

 

C:\Program Files\Microsoft
Office\Office10

 

Microsoft Excel 2000

 

C:\Program Files\Microsoft
Office\Office

 

Microsoft Office Excel
2007

 

C:\Program Files\Microsoft
Office\Office12

 

Microsoft Office Excel
2010

 

C:\Program Files\Microsoft
Office\Office14

 

If Excel starts as expected, the problem may have been due
to a corrupted shortcut to the program. To resolve this problem, create a new
shortcut to the Excel program that you can use to start Excel.

 

Method 2- Start Excel
in Safe mode

 

1. Click Start,
and then click Run. In Windows 8.1
and Windows 10, right-click the start button, and then click Run.

 

2. Type: Excel.exe /s.

 

If all these stated methods are incapable of restoring your corrupted file, then next most recommended solution will be to make use of a third party repair tool and MS Excel Repair Tool is most appropriate option for this purpose. It is designed by professional with highly advanced algorithms and that scans deeply and repair and rescue corrupted Excel file without any issue.

 

repairmsexcel.com

Share this post


Link to post
Share on other sites

×