I have a spreadsheet that accesses an external database (MS Access).
Every once in a while after the file is closed and re-opened, I get a
message that "file.xls" is currently locked for editing (by me). I'm
not sure why this occurs. I'm guessing that the connection to the
external database is the culprit if it is not properly closed. If this
is the case, what can I do to ensure the connection is closed each
time, especially if my code crashes?

I can easily work around this issue by creating a copy of of the file,
which I'd rather not do in the event I work out all of the bugs and let
others use this application.

Any ideas?

Thanks,
Mike.

Make sure the backgroundquery property is set to false would be my guess.

--
Regards,
Tom Ogilvy


"Michael Malinsky" wrote in message
oups.com...
I have a spreadsheet that accesses an external database (MS Access).
Every once in a while after the file is closed and re-opened, I get a
message that "file.xls" is currently locked for editing (by me). I'm
not sure why this occurs. I'm guessing that the connection to the
external database is the culprit if it is not properly closed. If this
is the case, what can I do to ensure the connection is closed each
time, especially if my code crashes?

I can easily work around this issue by creating a copy of of the file,
which I'd rather not do in the event I work out all of the bugs and let
others use this application.

Any ideas?

Thanks,
Mike.