At our office multiple users located at worldwide sites do use a certain shared Access database.
This database is set up as a backend database and all communication is performed via SQL commands using an Excel frontend.
Sometimes the database becomes in “inconsistent state”, which can be repaired easily by opening the database (in runtime mode) and let Access do the repair. Since the database is encrypted using a password this semi-manual repair can only be done by an admin.
Because the admin is not 7x24 available, I like to set up an auto recovery which can be started when the database is detected in inconsistent state.
I am looking for a VBA script to repair an inconsistent encrypted database without applying manual actions.
Unfortunately, still without success...
So, is there a way to repair an encrypted database just by using VBA (or any other method)?
This database is set up as a backend database and all communication is performed via SQL commands using an Excel frontend.
Sometimes the database becomes in “inconsistent state”, which can be repaired easily by opening the database (in runtime mode) and let Access do the repair. Since the database is encrypted using a password this semi-manual repair can only be done by an admin.
Because the admin is not 7x24 available, I like to set up an auto recovery which can be started when the database is detected in inconsistent state.
I am looking for a VBA script to repair an inconsistent encrypted database without applying manual actions.
Unfortunately, still without success...
So, is there a way to repair an encrypted database just by using VBA (or any other method)?