At 1:09 PM +0200 9/5/01, Admin wrote:
>I've had good luck using an access database with tables linked to the excel
>sheets. This way you can use all the features of access like views etc and
>you can swap out the excel file without having to worry about the file being
>locked by the cf server.
The only way I could get this to work is to duplicate the server
directory path on the local machine, do the link, then upload both
files.
It appears as if the absolute path to the link target is stored
somewhere in the Access mdb file.
Is there any way to change this absolute path, other than editing the
.mdb file?
TIA
Dick
>----- Original Message -----
>From: "Mike Kear" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, September 05, 2001 11:23 AM
>Subject: Excel as a datasource .... ?
>
>
>>
>> I have a client who's complaining that the time spent generating a small
>app
>> using SQL is costing too much and wants to use excel spreadsheets instead.
>>
>> What's your experience using excel as a datasource?
>>
>> Just to clarify what the projects do, they don't write to the datasource,
>> just look up and filter the data customising tables for the user's needs.
>> The volumes aren't great - between a few hundred page views a month to
>5000
>> or so.
>>
>> IS there likely to be implications for the usage of RAM and resources on
>the
>> server? The System Admin is already complaining that he has to restart
>the
>> server too often and when the processor usage gets to 100% he panics and
>> complains.
>>
>>
>> Cheers,
>> Mike Kear
>> Windsor, NSW, Australia
>> AFP WebWorks
>>
>>
>>
>>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
