|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
New user locks others out when openUser has a very old database. Conversion to Access 2002 SP1 took place some
time ago and it has worked fine since that conversion. Problem started when a new person (ABC) was added. When ABC is in the database, all other users are locked out. If anyone else is in database, no one else is locked out. I've been reading here about using a "Security Wizard" but I am not a regular Access user and have not worked with it. Any tips I can give the user on how to change the security level on the new person? -- Brenda Brenda from Michigan wrote:
> User has a very old database. Conversion to Access 2002 SP1 took They don't have adequate permissions to the folder where the file resides. They > place some time ago and it has worked fine since that conversion. > Problem started when a new person (ABC) was added. When ABC is in > the database, all other users are locked out. If anyone else is in > database, no one else is locked out. > > I've been reading here about using a "Security Wizard" but I am not a > regular Access user and have not worked with it. Any tips I can give > the user on how to change the security level on the new person? are unable to create the LDB file when they open the MDB file and that LDB file is required for multi-user access. Hence, they end up opening the file exclusively. Either that are they are opening the file exclusively because that is how they have Access configured as the default file open mode. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Thanks for the quick post. The user says that person ABC is currently
writing to the database so we assume she has write permissions to this folder. I'm not familiar with the "default file open mode" and neither is the user I'm speaking with. Can you shed any info on where/how to check this? -- Brenda Show quote "Rick Brandt" wrote: > Brenda from Michigan wrote: > > User has a very old database. Conversion to Access 2002 SP1 took > > place some time ago and it has worked fine since that conversion. > > Problem started when a new person (ABC) was added. When ABC is in > > the database, all other users are locked out. If anyone else is in > > database, no one else is locked out. > > > > I've been reading here about using a "Security Wizard" but I am not a > > regular Access user and have not worked with it. Any tips I can give > > the user on how to change the security level on the new person? > > They don't have adequate permissions to the folder where the file resides. They > are unable to create the LDB file when they open the MDB file and that LDB file > is required for multi-user access. Hence, they end up opening the file > exclusively. > > Either that are they are opening the file exclusively because that is how they > have Access configured as the default file open mode. > > -- > Rick Brandt, Microsoft Access MVP > Email (as appropriate) to... > RBrandt at Hunter dot com > > > Brenda from Michigan wrote:
> Thanks for the quick post. The user says that person ABC is currently Doesn't matter what they can do in the app. That only tells you what > writing to the database so we assume she has write permissions to this > folder. I'm not familiar with the "default file open mode" and > neither is the user I'm speaking with. Can you shed any info on > where/how to check this? permissions they have on the MDB file itself. They need the ability to create new files in that folder as well. See if that user can create a new text file in that folder for example and then delete it. In your file - open dialog in Access you can open a file for shared access or you can open it exclusively. There is a setting in options that determines what the default is for that. You need to make sure it is set to shared. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com I located the default mode in Help. The user confirms that ABC has a default
mode of Shared. I don't see anything else in Options that appears to point toward this problem. Any other suggestions? -- Brenda Show quote "Rick Brandt" wrote: > Brenda from Michigan wrote: > > User has a very old database. Conversion to Access 2002 SP1 took > > place some time ago and it has worked fine since that conversion. > > Problem started when a new person (ABC) was added. When ABC is in > > the database, all other users are locked out. If anyone else is in > > database, no one else is locked out. > > > > I've been reading here about using a "Security Wizard" but I am not a > > regular Access user and have not worked with it. Any tips I can give > > the user on how to change the security level on the new person? > > They don't have adequate permissions to the folder where the file resides. They > are unable to create the LDB file when they open the MDB file and that LDB file > is required for multi-user access. Hence, they end up opening the file > exclusively. > > Either that are they are opening the file exclusively because that is how they > have Access configured as the default file open mode. > > -- > Rick Brandt, Microsoft Access MVP > Email (as appropriate) to... > RBrandt at Hunter dot com > > > It's a Windows permission problem. They need read/write/create/delete permission on the folder.
Although delete isn't absolutely necessary, it's recommended. -- Joan Wild Microsoft Access MVP Show quote "Brenda from Michigan" <BrendafromMichi***@discussions.microsoft.com> wrote in message news:95AACFB7-570C-433F-B0EB-DE297B35320B@microsoft.com... >I located the default mode in Help. The user confirms that ABC has a default > mode of Shared. I don't see anything else in Options that appears to point > toward this problem. Any other suggestions? > -- > Brenda > > > "Rick Brandt" wrote: > >> Brenda from Michigan wrote: >> > User has a very old database. Conversion to Access 2002 SP1 took >> > place some time ago and it has worked fine since that conversion. >> > Problem started when a new person (ABC) was added. When ABC is in >> > the database, all other users are locked out. If anyone else is in >> > database, no one else is locked out. >> > >> > I've been reading here about using a "Security Wizard" but I am not a >> > regular Access user and have not worked with it. Any tips I can give >> > the user on how to change the security level on the new person? >> >> They don't have adequate permissions to the folder where the file resides. They >> are unable to create the LDB file when they open the MDB file and that LDB file >> is required for multi-user access. Hence, they end up opening the file >> exclusively. >> >> Either that are they are opening the file exclusively because that is how they >> have Access configured as the default file open mode. >> >> -- >> Rick Brandt, Microsoft Access MVP >> Email (as appropriate) to... >> RBrandt at Hunter dot com >> >> >>  |
|||||||||||||||||||||||
Other interesting topics