Changing from excel to Access isn't an option, this is syndicated info
provided in excel. However - you make it sound like Access can
'automatically' link to an excel file, and that access file can be used as
the DSN...can you explain this a little better.
No caching no where.
>From: "Gregory Harris" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: DSN locking options...HELP
>Date: Tue, 03 Oct 2000 10:16:04 -0700
>
>The nice solution to this would be to replace the Spreadsheet w/an Access
>database, and use DDE to let Excel upload the spreadsheet data directly to
>access. However if you must use a CF solution, I would check to make sure
>that you aren't using query caching (the cachedwithin or cachedafter
>attributes in <CFQUERY> are your clue). Also there is some sort of
>"buffer" setting in the Cfadmin that needs to be set to zero if I recall.
>Can't remember it offhand, but hope some of this helps...
>
>Gregory Harris
>Los Angeles Information Technology Agency (ITA)
>[EMAIL PROTECTED]
>
>
> >>> [EMAIL PROTECTED] 10/03 9:55 AM >>>
>Hello All,
>
>I am connecting to an Excel SS as a datasource, and I need to upload a
>fresh
>SS file once a day, the problem arises on the upload...The file (by the
>same
>name) uploads without throwing an error (using CFFTP to do so) BUT any
>queries to the DS return the OLD data...If I go into the CF Admin and
>disconnect and reconnect...then the new data shows up.
>
>I have the "Maintain database connections" un-checked
>and the Timeout set to "1 min" (Waiting over 1 min yields no difference
>from
>the above scenerio)
>
>HELP!
>
>TIA - JP
>
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.