I just moved an Access Database to a new server (from Server 2003 to Server 2012). From the server, using Office 2010, I can open the database without issue but, if a user try's to open the same database from either a shortcut or mapped with Office 2010, they get the message that the database is Read Only. Did I miss a step in moving the database to the new server? Thanks

Hi,

Did your user get the error message "You are trying to open a read-only database..."? If it was, please try the following method:

• 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.

Resource:

http://support.microsoft.com/kb/324666/en-us (It also applies to Access 2010)

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support

Thanks for the suggestion however, the read only is checked all the way up to the top level of the folder. no mater what level of the folder or the file itself, when I remove the 'read only' check mark and close the attributes page, read only is checked again when I reopen the attributes. How can I remove it at all levels of the folder and keep it removed? Thanks

Hi,

According to your description, I suppose that issue is more related to the permission with Windows sever 2012. We may check the permission first, then, I recommend you post the question to Windows sever 2012 forum, you may get some idea there:

https://social.technet.microsoft.com/Forums/en-US/home?forum=winserver8gen&filter=alltypes&sort=lastpostdesc

Regards,

George Zhao
TechNet Community Support