Database locking issue (1 Viewer)

majid.pervaiz

Registered User.
Local time
Today, 11:31
Joined
Oct 15, 2012
Messages
110
Dear All,
I have a database which I have divided into front end for multiple users and backend (I.e database) on a shared server. This shared server is managed by IT team and the folder where I have database we have read and write permissions.
we are around 10 users of this shared database.
Suddenly, the database is locked and only one user is able to access is. Anytime 2nd user is trying to access it gives an error file is already in use.
Even though everyone logged out of database but still lock file is showing next to the main database file.
Please help to explain in an easy way since I am not too much tech guy.
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 03:31
Joined
Feb 28, 2001
Messages
26,996
I'm going to step in with a different answer ONLY because it is possible that your issue isn't the bug that both theDBguy and arnelgp have referenced. (BUT this is if and only if their answer doesn't work... 'cause they are probably right.)

The problem may be incorrect permissions. If you have only read/write permissions, that might not be enough. You need MODIFY permissions on the shared folder and the files in it. If your IT guys object, offer them this detailed solution:

Create a GROUP IDENTIFIER with some convenient name. Create an Access Control List on the shared folder and (as is normally the case) allow all permissions to be inherited to the files in that folder. Besides the usual ADMINISTRATOR:FULL CONTROL entry and some entries granting elevated privileges for BACKUP OPERATOR and whatever other administrative overhead is required/customary, have a later entry with this newly created group identifier having MODIFY permissions, but then have a FINAL entry with EVERYONE:NO ACCESS (and when I say final, I mean it. The NO ACCESS entry MUST be the last one in the list.) That should give pretty good protection on the shared files. And then, give the IT folks a list of users who need to be granted that group identifier (including yourself).
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 04:31
Joined
Feb 19, 2002
Messages
42,970
You'd think if MS could come up with a fix in three days that they could stop the bad update from spreading around the country and around the world:(
 

GPGeorge

Grover Park George
Local time
Today, 01:31
Joined
Nov 25, 2004
Messages
1,775
You'd also think MS would do minimal acceptance testing before releasing updates.....
 

Minty

AWF VIP
Local time
Today, 08:31
Joined
Jul 26, 2013
Messages
10,353
You'd also think MS would do minimal acceptance testing before releasing updates.....
They need something for the Access developers to do.
They've been twiddling their thumbs for at least 12 months...
 

Minty

AWF VIP
Local time
Today, 08:31
Joined
Jul 26, 2013
Messages
10,353
Oh yes - re-inventing sharepoint, sorry I forgot.
I wish I could see the point, but maybe I need new glasses.

There is nothing in the "Dataverse" that can't be better achieved with a proper RBDMS be it SQL, Azure, Oracle, SQL Express.
If someone can tell me otherwise I'm all ears, and will go to Specsavers.
 

majid.pervaiz

Registered User.
Local time
Today, 11:31
Joined
Oct 15, 2012
Messages
110
I'm going to step in with a different answer ONLY because it is possible that your issue isn't the bug that both theDBguy and arnelgp have referenced. (BUT this is if and only if their answer doesn't work... 'cause they are probably right.)

The problem may be incorrect permissions. If you have only read/write permissions, that might not be enough. You need MODIFY permissions on the shared folder and the files in it. If your IT guys object, offer them this detailed solution:

Create a GROUP IDENTIFIER with some convenient name. Create an Access Control List on the shared folder and (as is normally the case) allow all permissions to be inherited to the files in that folder. Besides the usual ADMINISTRATOR:FULL CONTROL entry and some entries granting elevated privileges for BACKUP OPERATOR and whatever other administrative overhead is required/customary, have a later entry with this newly created group identifier having MODIFY permissions, but then have a FINAL entry with EVERYONE:NO ACCESS (and when I say final, I mean it. The NO ACCESS entry MUST be the last one in the list.) That should give pretty good protection on the shared files. And then, give the IT folks a list of users who need to be granted that group identifier (including yourself).
Dear we have modify permission as well on the folder
 

Users who are viewing this thread

Top Bottom