Good day,

We are using MS Access 2016 (and Office 365) in conjunction with a 20 year old MDB database that was not converted to an .accdb database.  It has been working fine until a couple of days ago.  The Db is divided into small, similar front-end Dbs and a much larger back-end Db on a shared network drive.  On 4 of 5 workstations where the front-ends are installed we have no problems to speak of.  On one workstation VBA is giving me grieve.  It looks like a library is lost as VBA code no longer runs properly.  Obviously to change anything and save the changes in the front-end Db, I need exclusive access.  I cannot solve the dilemma of granting the “admin” ( = only user) exclusive access.  The admin logically has “administer” access.  When I try to set the flag for “open exclusive” I get the following message: You cannot change permissions for “Current Database”. To change permissions for this object you must have Administer permissions for this object.
This very much feels like a conflict as I do have Administer permissions.
Looking forward to any good advise.  Thank you.

​Good day,We are using MS Access 2016 (and Office 365) in conjunction with a 20 year old MDB database that was not converted to an .accdb database.  It has been working fine until a couple of days ago.  The Db is divided into small, similar front-end Dbs and a much larger back-end Db on a shared network drive.  On 4 of 5 workstations where the front-ends are installed we have no problems to speak of.  On one workstation VBA is giving me grieve.  It looks like a library is lost as VBA code no longer runs properly.  Obviously to change anything and save the changes in the front-end Db, I need exclusive access.  I cannot solve the dilemma of granting the “admin” ( = only user) exclusive access.  The admin logically has “administer” access.  When I try to set the flag for “open exclusive” I get the following message: You cannot change permissions for “Current Database”. To change permissions for this object you must have Administer permissions for this object.This very much feels like a conflict as I do have Administer permissions.Looking forward to any good advise.  Thank you.  Read More

​