Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shared xls using ODBC/JET
Greetings.
In a LAN, while a user is working on an XLS file, form many other hosts a tool I have to write should be able to view information from it (using ODBC). My test works only when the XLS file is closed. When it is opened (on the machine where they modify it through Excel), I get: The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user... (Another strange case: it happened that my code receives 'actual' values when the xls is closed, 'possibly older values', without returning the above mentioned error, when it is opened). Operations on that book.xls is mandatory (ie: I cannot translate it into another db format). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using forms in a shared workbook | Excel Worksheet Functions | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
Shared Worbook Accessible on an Intranet | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) |