I have a sheet where I have data from an Access table imported (Data --
Import External Data -- Import Data...). No problem there. What I've
discovered is that a connection, it seems, stays open between Excel and Access
so that, in effect, that particular Access data source is "open" and remains
so until Excel is closed or the Excel file is Saved As something else -- but
if Refresh Data is performed then that link is established again and the
problem is back.

Now this is bad because the Access mdb cannot be opened for
changes/edits/modifications because it acts like it is opened by another user
(and technically it is). So I'm thinking about having VBA severe the
connection after the data has been downloaded because that's what seems to
happen when the file is saved elsewhere or if it's opened without a Refresh.
Can this be done and if so, how?
--
Toby Erkson
Oregon, USA