[AccessD] database locked by user admin at machine " " error

I run into this same problem. I have a database in 97 & if I make any
changes & compile, when someone tries to open it using 2k they receive the
message about "locked by..." then I get calls "can't more than one person
use the database at a time?" It also happens on databases created in 2K. I
have never been able to figure out why. Once the current user closes the
database & the other person opens it, they don't get the message again
unless I make changes & compile again.

If anyone finds an answer to this I would appreciate it too.

Virginia

-----Original Message-----
From: MartyConnelly [mailto:martyconnelly at shaw.ca]
Sent: Tuesday, July 22, 2003 11:34 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] database locked by user admin at machine " "
error


It could be a lot of  things. What level of Office was this developed 
on. What service pack and System Release of Jet, but could it be that 
someone is opening the mdb or adp to perform programming edits and this 
has to be done in exclusive mode or someone could be just opening the 
mdb by clicking on the file directly to do data edits. There is an 
option from Tools menu to force either shared or exclusive opening but 
this can overridden. I can give you some code to force a shared open and 
if some tries an exclusive open indicates machine and user name.


Bonnie Snider wrote:

>I have a database that resides on a netware 6 file server and serves
>about 30 user across a wide area network.  All users belong to a group
>that has full rights to the directory in which the database is located. 
>Usually there will be three or four users trying to access the database
>at the same time. 
>
>Users access the data via  data access pages over the internet.  Some
>days there are no problems with access to the database.  Other days if
>even one user is already logged into the database a second user will get
>the error message that  the database is locked by user admine at machine
>"(machine name)".    Sometimes they will continue to get the message
>even after the first user logs out of the the database.    Sometimes
>they are able to open the access pages, but then are unable to enter
>data.   Any suggestions or ideas as to what the problem may be?
>
>Bonnie Snider, LAN Administrator
>DWS North Admin
>Phone:   526-9253
>Cell:        430-1219
>FAX:       526-9744
>EMAIL:   bsnider at utah.gov 
>
>  
>


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