I have a secured database that had all its corresponding files deleted (bak, image of screenshot, .secure file). I have tried rebuilding this database by copying and pasting the objects in it into a new database, but because it is secured, I can't do this with forms, reports, or macros in the database (I can't look at their design either). Is there a way to restore the functionality of the database either by restoring the original database or by copying the forms, reports, and macros into a new database?
-
-
@Stevestan1,
What's stopping you from restoring your DB backup and rolling forward from there? It sounds like things are untennable at the moment.
Another way of asking is "what would be lost"?
Luck! -
The backup was deleted along with all the corresponding secured database filesComment
-
Oh. (in the typical downfalling voice indicating shared frustration.)
Do you know how to break into a secured database? I think you use "shift-click", or "cntrl-click", when you open it. However, the real Access experts here can tall you for sure. That'll be like opening the DB without all the overhead.
Another thing you can do is to set your version of access to disable macros, or some such. Then it comes up in an effectively unsecured manner. Then you can open things in design mode.
We do that around here, because the company enforces it as a security policy. It keeps folks from sending virus databases in and having the code auto-executed.
We are rapidly getting to the point where my advice will do you more harm than good, though. Be careful and keep backups at every major step, so you don't accidentally destroy something.
Good Luck!Comment
-
Tried the shift-click and cntrl-click; the security settings are still there. I don't think any locks were disabled.
How do you disable macros in Access?Comment
-
In the "Trust Center", there is a "Macro Settings" option.
Under that tab, there is an option to disable all macros with notification, which is what I use.
Can you find it?Comment
Comment