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 >