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

Thanks Guys,

After sending this question last night I shut down my computer and went to
have a cool one. Away from the office it hit me. I have another routine that
opens an ADO connection and gets the Name of the first sheet in the work
book. The connection was not closed and it was locking the spreadsheet. For
some reason this never caused a problem in Access 2002.

Think I need to drink more. I'd probably be much more productive.

Thanks for your thoughts.

Doug

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Monday, April 16, 2012 9:06 PM
To: Access Developers discussion and problem solving
Subject: Re: [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.
> 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com