Hi Toby,

This isn't the way it's supposed to work (at least I have never run into
this before). Do you have your MDB set up as a single-user database (set to
open exclusively)? What exact steps did you take to set up the database
query?

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Toby Erkson wrote:
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?