Persistent Connection Excel

E

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
 
P

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Linked Table Problem 5
transferspreadsheet aclink permissions 7
Performance Question (Persistent Connection) 12
Access to Excel link 2
linking to an Excel spreadsheet 1
Persistent Connection 11
Update Query from Access 2003 Linked Table 1

Top