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

Doug Steele dbdoug at gmail.com
Tue Apr 17 11:09:03 CDT 2012


Your are correct.  Recent research confirms it:

http://consumerist.com/2012/04/researcher-says-a-bit-of-beer-may-help-creative-problem-solving.html


Doug

On Tue, Apr 17, 2012 at 8:58 AM, Doug Murphy <dw-murphy at cox.net> wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list