Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
matteodipane
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using forms in a shared workbook Dan23 Excel Worksheet Functions 3 August 9th 05 03:31 PM
Hidden Columns in Shared Workbooks Rotary Excel Discussion (Misc queries) 1 July 9th 05 12:28 AM
Shared Worbook Accessible on an Intranet Paul. Excel Discussion (Misc queries) 2 April 14th 05 11:18 AM
Freeze Pane problem in shared workbooks JM Excel Discussion (Misc queries) 1 February 1st 05 12:04 AM
Shared File & Freeze panes issue JM Excel Discussion (Misc queries) 0 January 21st 05 07:01 PM


All times are GMT +1. The time now is 09:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"