A
acx
Hello,
I need a help with this problem. I have linked some larger Excel tables
to my Access application. Every operation (insert, delete) on these
linked tables is extremely slow when the Excel file is open but very
fast when the file is closed.
I want to know how to ensure programically in Access that before
starting of any operation with the Excel-linked tables, the particular
Excel file is closed. I need somehow to find out whether the file is
open. If so, I would like to save the file and close it.
Many thanks for your help!
MikeX
I need a help with this problem. I have linked some larger Excel tables
to my Access application. Every operation (insert, delete) on these
linked tables is extremely slow when the Excel file is open but very
fast when the file is closed.
I want to know how to ensure programically in Access that before
starting of any operation with the Excel-linked tables, the particular
Excel file is closed. I need somehow to find out whether the file is
open. If so, I would like to save the file and close it.
Many thanks for your help!
MikeX