Open Access Code

[trgpham]

Hi All,

I have an existing access application which I need to open to modify the code. I press Shift + double click on the file (.mdb) but it start running the application, but not the code.

Does any one know what happen, and how can I open the code to modify it.

By the way, I tried Shift + open other MsAccess applications and it open the code fine.

Thanks and appriciate for any help.

regards,
John

[ADezii]

Hi All,

I have an existing access application which I need to open to modify the code. I press Shift + double click on the file (.mdb) but it start running the application, but not the code.

Does any one know what happen, and how can I open the code to modify it.

By the way, I tried Shift + open other MsAccess applications and it open the code fine.

Thanks and appriciate for any help.

regards,
John

It sounds like someone placed SHIFT ByPass code in the Database so as to disable this option. I'm assuming there is User Level Security on the Database, is this true?

[MMcCarthy]

Hi All,

I have an existing access application which I need to open to modify the code. I press Shift + double click on the file (.mdb) but it start running the application, but not the code.

Does any one know what happen, and how can I open the code to modify it.

By the way, I tried Shift + open other MsAccess applications and it open the code fine.

Thanks and appriciate for any help.

regards,
John

Hi John

The shift bypass key has probably been disabled in the code. Most good developers will do this before releasing a database to users. Developers normally keep a version for development purposes without these security controls.

Mary

[MMcCarthy]

It sounds like someone placed SHIFT ByPass code in the Database so as to disable this option. I'm assuming there is User Level Security on the Database, is this true?

Snap ............... ..

[trgpham]

You are right Mary, it's coded to by pass the Shift Key by setting CurrentDB.Prope rties("AllowByP assKey")=False

However you can still open the code by double click on the program, right click on the screen and select Open Database, then select menu Window and select Unhide...

John.

[MMcCarthy]

You are right Mary, it's coded to by pass the Shift Key by setting CurrentDB.Prope rties("AllowByP assKey")=False

However you can still open the code by double click on the program, right click on the screen and select Open Database, then select menu Window and select Unhide...

John.

You're lucky the Window menu is available to you. I would have replaced it with a custom menu. :)