Forum Discussion

Ian_Johnston_1948's avatar
Ian_Johnston_1948
Brass Contributor
Mar 04, 2024

Access to Access

I am a single user using OneDrive and 365. All of a sudden Access says I can't save edits because there is another user. There isn't. Occasionally the file locking file can be seen in Explorer but I ...
access
developer
office 365
George_Hepworth's avatar
George_Hepworth
Silver Contributor
Mar 07, 2024

Ian_Johnston_1948 

That appears to be a Windows error, which I don't recall seeing. It's not coming from Access, I don't think.

 

Make sure the accdb in the local folder has been made editable. There is a feature on files downloaded from the internet which marks them read-only. You can see that here, if it is. 

I would recommend a reboot of the computer. When it restarts, check the accdb for that flag.

 

Keep at it; you'll figure this out.

Ian_Johnston_1948's avatar
Ian_Johnston_1948
Brass Contributor
Mar 07, 2024
Yes, the database itself is not 'read only' but the folder is. When I change it, click 'apply', close the properties screen and then open it immediately, it has reverted to 'read only' again!
  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    Mar 07, 2024

    Ian_Johnston_1948 

    "Yes, the database itself is not 'read only' but the folder is. "


    We're approaching the border between my knowledge of Access and the vagaries of Windows. It seems this is more a Windows problem than an Access problem.

    Please try one more thing.

    Create a new folder on the C:\ drive, not in your users folder, directly on C:\

    Put the accdb in that new folder, for example;

    C:\TestFolder\youraccdbnamegoeshere.accdb 

     

    Make that TestFolder a Trusted Location.

     

    Still no luck?

     

Resources