I moved our MS access database from Windows server 2003 to Server 2008 R2. The database is split, and also uses security.mdw. The most immediate issue was that the tables were read-only unless the user sets their shortcut to "Run as Administrator." Is there a way to address that? The client is MS Access 2010.
Also, I would like to get rid of the security.mdw function, but Google confuses me. Is there a clear procedure to do that?