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

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

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
    ... I'm no expert on Windows security, but I think you have to update the folder ... (Windows permission) ... on the folder where the mdb is located. ...
    (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: Folder redirection error
    ... Yeah it was the share permission. ... Folder Redirection feature in Windows ...
    (microsoft.public.windows.server.active_directory)
  • i can not delete folder, because i do not have any permission
    ... i create a folder on my file server via batch, but this folder did not have ... any permission including system and local administrators. ...
    (microsoft.public.windows.file_system)