![]() ![]() ![]() 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. 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).Įxcel can make use of two database drivers: Jet OLE DB et ACE.OLEDB. Most likely the problem the OP has is with OLE DB network access driver compatability. Our problems with Oracle are only due to our Oracle client, which is massively cumbersome. We also use an Oracle DB for some stations, but both Excel and Oracle have their own drawbacks. We use it in a production environment with multiple stations accessing the DB. Once it's done (a second or 2 usually), it becomes available again. I suggest that you use a proper database instead of Excel for more sophisticated record level locking and access types.īarTender appears to lock Excel only while it is actually quereing for data. ![]() Excel uses exclusive file locking, meaning that only one application/computer can connect to it at any one time. This is a limitation of Excel I'm afraid. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |