External database causing problems?
 

I posted a question a while ago regarding code that accessed an Access
database. Occasionally, when I try to open the Excel file, I get a
message that the file is locked for editing. I am unsure as to why I
am getting this error. Tom Ogilvy responded by stating "Make sure the
backgroundquery property is set to false would be my guess. "

So two questions, is Tom's solution the correct one and if so, how do I
properly include this in my code?

Thanks,
Mike.