Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Monday, March 2, 2015 3:56 PM
An Access application with linked databases opens read only, but sometimes is editable. The system was developed in Access 10 on a Win 7 machine and migrated to a standalone laptop running Win 8 and Office 365.
The Access 10 has no problem in operating the application. The Win 8 laptop randomly opens the application read only. I have reviewed Trust settings and there is no difference between the different laptops and systems.
Is this a common problem? Is it associated with Win 8? Is it associated with Access form Office 365? The application is crucial to the business and we are getting way behind because we don't have a reliable or useful system. Last year the same application ran satisfactorily on Win 7 and Access 10.
I would welcome some thoughts leading too a solution.
All replies (1)
Tuesday, March 3, 2015 5:20 AM âś…Answered
Hi,
Did you get the error message like "You are trying to open a read-only database". If yes, this issue may be due to the permission of the Access database. If we migrate the Access database from Access 2010 to Access 2013, the user/account's permission may be changed with different Windows operation system. We need the full control permission of the Access database. To workaround this issue, follow these steps:
- On the desktop, double-click My Computer.
- Locate the Microsoft Access database that you moved.
- Right-click the database name, and then click Properties.
- In the Properties dialog box, clear the Read-only check box under Attributes.
- Click OK to apply the change.
- Open your database in Access.
Please note: Make sure the user has full control of the root folder.
If no, please tell us the whole error message, we'd like to do further troubleshooting.
Regards,
George Zhao
TechNet Community Support
It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.