View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Malinsky Michael Malinsky is offline
external usenet poster
 
Posts: 24
Default 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.