Access Security and Protection

[Aaron78]

Hi all,

I've recently taken over a database that a collegue of mine was developing and he has disabled certain functions within the database which I can't enable. Specifically, he has disabled the ability to right click over anthing in design view so you can view the list of options available. Does anyone know how I can re-enable this feature?

Best Regards,

Aaron

 

[Len Boorman]

There is a property of the form Shortcut toolbar I think. It has probably been set to False

Len

 

[meanster99]

make sure you hold down shift when you click on 'open' (at the security warning about macros AFTER double clicking the mdb file)

 

[Aaron78]

Thanks. The shift thing worked.

Is there anyway to permanently enable it?

 

[meanster99]

Im not sure about that. With my db I only had to start pressing the shift key once I had created an autoexec macro that opened my switchboard and maximised it. Have you got an autoexec macro? (or maybe check the startup option in the Tools menu)

 

[Len Boorman]

Thanks. The shift thing worked.

Is there anyway to permanently enable it?

There is probably a function within a module that is fired by either the on load or on open event of the opening form that is maybe fired from an Autoexec macro.

So either
Delete the Autoexec macro (after checking exactly what it does
Amend the Opening Form properties

but do not do anything before you have taken a backup copy

Len