Locking excel sheet?

Using Excel,SQL,Oracle, and other ODBC Compliant Databases
Post Reply
Linas
Regular Contributor
Regular Contributor
Posts: 8
Joined: Wed Nov 13, 2013 3:17 pm

Locking excel sheet?

Post by Linas »

I am displaying data from an excel sheet and the Noventri player keeps locking the document so others cannot add new data?
how can I stop the file from getting locked?
Sergey K

Re: Locking excel sheet?

Post by Sergey K »

Hello Linas,

You will need to make sure you are using Microsoft's latest AccessDatabaseEngine ODBC driver available here.
You can follow the post below to download the latest drivers and setup your project to use them.

http://www.noventri.com/forum/viewtopic.php?f=73&t=486

Please let me know if you have any other questions.

Kind Regards,
Linas
Regular Contributor
Regular Contributor
Posts: 8
Joined: Wed Nov 13, 2013 3:17 pm

Re: Locking excel sheet?

Post by Linas »

Not sure where I need to load this?
Do I need to install this on each computer that updates the excel sheet?
Also from reading the link they mention *.xlsx so this means we need to be using excel 2010 or newer?
Sergey K

Re: Locking excel sheet?

Post by Sergey K »

Hello Linas,

The AccessDatabaseEngine drivers should be installed on each computer running the Noventri Suite or Server software. After installing the driver, you may have to restart your computer for the new driver to take effect (this depends on your operating system). This is important because the selected driver is saved when building a Suite project. If that driver is not found on the Server computer, the project will select a generic driver, preventing access to the file while it is still open.

This driver allow for reading of the following file types (extension):

Excel 97-2003 Workbook (.xls)
Excel 2007-2010 Workbook (.xlsx)
Excel 2007-2010 Macro-enabled workbook (.xlsm)
Excel 2007-2010 Non-XML binary workbook (.xlsb)

You will be able to use any of the above Microsoft Excel version with this driver.

If you have any further questions, please let me know.

Thanks,
Post Reply