[AccessD] Errors 3045 and 3027

Rocky Smolin rockysmolin at bchacc.com
Wed Jul 23 18:12:43 CDT 2014


Thanks Stuart.  I'll pass that along.

R
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Wednesday, July 23, 2014 4:09 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Errors 3045 and 3027

Sounds like permissions on the server rather than an Access issue.

You will get exactly this if the directory allows  Create but not Modify.  

First problem:   No one can  modify the main data file.

Second problem:  The first user in can create the lock file, subsequent
users can't modify it so can't get in - Access thinks it has been opened
"exclusive".  As soon as the first user logs out, the lock file is deleted
and another user can then log in and create a new one.


Cure:  Give all users nmodify rights on the directory.


--
Stuart

On 23 Jul 2014 at 9:04, Rocky Smolin wrote:

> Dear List:
> 
> An mde compiled in 2003 is suddenly throwing error 3077 - Error 3027 -
> Cannot Update. Database or Object is Read Only.   and 
> 
> Error: 3045 - Could not use (db name) File Already in Use.
> 
> I think it may be related to Access 2013 as so far all users reporting 
> this error are using 2013.
> 
> I'm not using ODBC nor user security (MDW).  Both problems are related 
> to the back end on the server. The 3077 occurs when a second user 
> tries to open the back end from a copy of the mde on a different 
> client machine.
> 
> Any ideas what might be causing this and a cure?
> 
> 
> 
> MTIA
> 
> 
> 
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com 
> <http://www.e-z-mrp.com/>
> Skype: rocky.smolin
> 
> --
> 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