Re: The database has been placed in a state...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I would still double-check the windows permissions for the problem user.
They are somehow opening the file exclusively. If the permissions are
correct, check to see if they are using a shortcut with the /excl switch or
using File, Open Exclusive.

I'm betting permissions.


--
Joan Wild
Microsoft Access MVP

Grace wrote:
Hi Joan,

Yes, I was referring to Windows permissions also. In the permissions
for the folder, under advanced Modify includes Delete but not Delete
Subfolders and Files
--
Grace


"Joan Wild" wrote:

I was referring to Windows permissions. *All* users need create and
delete permissions on the folder.

Once everyone is out, check that the ldb disappears. If it's still
there, delete it.


--
Joan Wild
Microsoft Access MVP

Grace wrote:
Hi Joan,

Thank you for replying. The groups that the users belong to have
modify permissions. Could not having delete permissions have
something to do with it? Also, from what I understand, the ldb file
is created when the database is opened and gets deleted when the
program is closed. I opened the ldb file with notepad while the
database is opened by someone else and this is how it looked like.

PC032 Admin PC041
Admin

Is there something wrong with this file?
--
Grace

"Joan Wild" wrote:

You should verify that user41 (as well as all users) has
read/write/create/delete permission on the folder where the
database is located. They need this in order to create the
associated ldb file. Without the create permission, they can't
create the ldb and therefore open the mdb exclusively.

--
Joan Wild
Microsoft Access MVP


"Grace" wrote:

We are using MS Office Professional 2003. We have a database that
is being accessed by a lot of people in our office.

The problem is that when this particular user (user41) is the
first one to open up the database in the morning nobody else can
open the database unless he closes it, let's everybody open it in
their computers, then he opens it again.

The error that other users get on their PCs when user41 is on the
database is:

"The database has been placed in a state by a user "Admin" on
machine "PC041" that prevents it from being opened or locked."

Help!

Grace


.

Relevant Pages

  • Re: Probs accessing database for users of newly developed Superuse
    ... but the SuperUsers cannot get into it. ... You've double-checked their permissions and all are correct. ... I've included the code for when the form opens below. ... ' Minimize the database window and initialize the form. ...
    (microsoft.public.access.security)
  • Re: Probs accessing database for users of newly developed Superuse
    ... but the SuperUsers cannot get into it. ... double-checked their permissions and all are correct. ... I've included the code for when the form opens below. ... ' Minimize the database window and initialize the form. ...
    (microsoft.public.access.security)
  • Re: Issue: LDB Not Being Created
    ... I would totally agree that it is a rights issue (and was convinced it ... I open the database and the LDB gets created. ... file create permissions, then all other users of the network would be able ... However if one user opens up the file does not have correct permissions to ...
    (comp.databases.ms-access)
  • Re: Bypassing Login as Admin user
    ... her computer, but tries to open the database without even logging in, then ... (which can't happen because I have Admin set with no permissions). ... I checked her workgroup file, and she IS connected to the ... or incorrectly opens the database without the path and file name of ...
    (microsoft.public.access.security)
  • Re: Access Database - Locked out from Design
    ... What happens if the 'owner' of the ldb file tries to delete it? ... permissions issue - maybe your permissions are set up such that only the ... 1- User "A" opens the database, and Access creates the .ldb file in the ...
    (microsoft.public.access.tablesdbdesign)