Re: Access 2007 open mdb (2000) file read-only

I'm no expert on Windows security, but I think you have to update the folder
permissions after creating the group - something like apply to all
folders/subfolders/

--
Joan Wild
Microsoft Access MVP
"X. Zhang" <XZhang@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:00A994EB-AEE2-4BE0-A409-9365374CAD6C@xxxxxxxxxxxxxxxx
I'm very aware of they are two different things. I never mixed them up.
That's why I mentioned I did not care the mdw security.

I was saying was that even I created a windows local group TIMSUSERS and
added my account xidongz to it, then granted 'Modify' to TIMSUSER on the
folder, I still could not open mdb in r/w mode, that is, could not create
ldb
file.

Thank you anyway.

"Joan Wild" wrote:

You are mixing up the Access users/groups with the Windows users/groups.
They are not connected in any way.

All users of the database (regardless of version), need 'modify'
permission
(Windows permission) on the folder where the mdb is located.

You would do this by granting this to the Windows username, or more
likely
to a Windows group they are a member of.

This is needed so that a ldb file can be created in the folder. Without
the
ability to create the ldb, the mdb will be opened exclusively.

--
Joan Wild
Microsoft Access MVP
"X. Zhang" <XZhang@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8B66CC4A-701A-48F3-869A-EF44CC800F11@xxxxxxxxxxxxxxxx
Found the problem. Somehow, Windows Vista has different security
implemetations.

The current login user, e.g. xidongz, in the local Administrators group
and
I give local Administrators Full Control to the folder that contains my
mdb
file. It seems that this group permission has problem.

I tried to create a local group name TIMSUSERS and added xidongz to
this
group, then grand full control to TIMSUSER on this folder. No luck.

After I either explicitly give the current user xidongz 'Modify'
permission
or give the Users group 'Modify' permission to this folder, everything
works
fine.

To double confirm, I removed 'xidongz' or 'Users', leave local
Administrators and TIMSUSERS, the read-only problem happened again.

"Joan Wild" wrote:

"X. Zhang" <XZhang@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9FF02082-DB2D-4440-9A0B-13FBD911021F@xxxxxxxxxxxxxxxx
File properties no problem: read-only check box is CLEARED.

At this point, I do care the security.

I'm not sure what this means?

I have successfully opened a secure mdb (note it can't be accdb
format)
in
2007, but only if I use the correct mdw. You do this by using a
desktop
shortcut. So I don't understand how you are opening it from within
Access.

I don't know why it would be opened read-only.

--
Joan Wild
Microsoft Access MVP








.

Relevant Pages

  • Re: Access 2007 open mdb (2000) file read-only
    ... All users of the database, need 'modify' permission ... on the folder where the mdb is located. ... The current login user, e.g. xidongz, in the local Administrators group ...
    (microsoft.public.access.security)
  • Re: vbscript using getfolder
    ... the windows directory that the system walks thru the windows directory trying ... explorer does not give an exact size for the windows folder. ... following script get a permission denied error on vista even when run as ... restores normal error handling, and also clears any error condition. ...
    (microsoft.public.scripting.vbscript)
  • Re: easy way to change file permissions and owner?
    ... Take Ownership of a File or Folder in Windows XP ... I also have two> hard drives. ... I don't want the guest account to access my second hard drive> at all, so I changed the permission on the second drive and accidentally> denied myself from the drive as well. ... I have to modify each folder> and files on that drive so that I can gain access to my files. ...
    (microsoft.public.windowsxp.general)
  • Re: Access 2007 open mdb (2000) file read-only
    ... You are mixing up the Access users/groups with the Windows users/groups. ... All users of the database, need 'modify' permission ... This is needed so that a ldb file can be created in the folder. ... The current login user, e.g. xidongz, in the local Administrators group ...
    (microsoft.public.access.security)
  • Re: Folder redirection error
    ... Yeah it was the share permission. ... Folder Redirection feature in Windows ...
    (microsoft.public.windows.server.active_directory)
Quantcast