Persistent Connection Excel

[eighthman11]

Hello Everyone.

Quick question. I have an Access Application (Access 2000) in which
all tables in the application are linked SQL Tables except 1 which is
an Excel spreadsheet which is linked. The application is on a
terminal server as has a very quick response time except when the
linked Excel spreadsheet is being used.

The spreadsheet is located on the users "C" drive. The spreadsheet is
used for an import feature of the application. Would a persistent
connection to the spreadsheet help response time? Or if anyone has
any ideas for a quicker response time I would be very interested to
hear them.

Thanks Ray

 

[Pete D.]

Not sure how the user is using this spread sheet but if you could initate a
save of the spreadsheet and copy it locally, link to the local copy I think
you would be much more pleased with its performance. Kind of depends on how
often you import it. Could even setup a automatic routine to bring it
locally. I used this (kind of) with an access file when the T1 connection
was very poor between one old building and the rest of us. As they were
only adding records I didn't need to sync them, just append.