[AccessD] The microsoft access database engine can not open or write to the file

I doubt that is the problem since Doug said "After I step out of the code the query opens fine." 

-- 
Stuart

On 17 Apr 2012 at 3:58, Darryl Collins wrote:

> Doug,
> 
> First thing I would check is the trust centre and check you have the
> permissions correct.  Access 2010 is very touchy about these details. 
> I would check it for both Access and Excel and ensure you have full
> permission access to the folders where the database is saved. 
> 
> Cheers
> Darryl.
>