I have an Access 2007 front end (originally A2003 .mdb file) linked to an Access 2007 back end. I want some users to open the database and have full access. I want other users to open the database and have read-only privileges. The database uses the system.mdw file. For the read-only users I was hoping to have a desktop shortcut with a read-only switch, but all my efforts in this regard have failed. How do you open an Access 2007 database with linked tables in read only mode?
