Is there any way you can copy the file and use the copy? That was my first thought.
On Mon, Mar 10, 2008 at 8:29 AM, DURETTE, STEVEN J (ATTASIAIT) < [EMAIL PROTECTED]> wrote: > Hi all, > > Sorry for the off topic, but this has been a real pain in my behind. We > have a process were our SQL server reads in data from an Excel file. > From there the data is used in various CF pages. > > The problem is that the file that we import data from is opened by users > to make changes before the next data load. A few of them, when it's > their turn to edit the file, open the file and leave it open and leave > for the day. > > They are are internal customer and threats of corporate policy > violation, going to their bosses, etc have no effect. No matter if they > have the file open or not, if the data doesn't load, it's considered our > fault. > > Does anyone know of anyway to force SQL Server 2000 to open an excel > file in read only mode? That way I can get the data and not have to > worry anymore. > > I googled it, but I didn't find much, except how to track down who has > the file open. (Which doesn't help me). > > Thanks, > Steve > > > Steve Durette > SR IT Analyst > 586-466-7654 > [EMAIL PROTECTED] > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300845 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4