Database protection - Old mdb completely locked out

Yattaro

Registered User.
Local time
Today, 16:00
Joined
Dec 21, 2012
Messages
15
Hi all,
I have an old *.mdb database that has nearly all controls locked out, if i click File and i'm unable to save or click options.
I have managed to get into the VBA, I'm not sure where to start looking for how they locked out all the database controls.
I'm sure its been locked out in the VBA somewhere, i just don't know what syntax to look for.
Placing the database into safemode wields no benefit.

Any advise would be appreciated.
 
bring the form in Design view.
check the Property Sheet->Data tab->Allow Edits, set it to Yes.
on VBA, "search" for Locked, if it is set to True (or -1) Set it to False (or 0).
 
I haven't found any controls that would lock out the ribbon bar and save options so far.
As an experiment, backed up the database and deleted all Objects from the database, table queries, modulus and forms and macros and it still locks out all the functions.
 
bring the form in Design view.
check the Property Sheet->Data tab->Allow Edits, set it to Yes.
on VBA, "search" for Locked, if it is set to True (or -1) Set it to False (or 0).

Found what i was looking for thank you for spending the time replying
 
Can you share the solution?
For what ever reason the 'File' 'Options' had its name changed to 'Privacy Options' from there i was able to Access the 'Access Options' and 'Current Database' options. At which point i enabled 'Allow Full Menus' and a few other options that had been disabled.
 
For what ever reason the 'File' 'Options' had its name changed to 'Privacy Options' from there i was able to Access the 'Access Options' and 'Current Database' options. At which point i enabled 'Allow Full Menus' and a few other options that had been disabled.
Hi. Glad to hear you got it sorted out. Cheers!
 

Users who are viewing this thread

Back
Top Bottom