Unlock database in access 1997

[Kinnari]

Hello,
My company has an access database 1997 (.mdb) that has been left behind by a previous programmer. Now, this programmer has locked this database. I can not update reports and can not read VB codes he wrote for reports.
I can open back end with mdb file, but can not see reports.
I tried shift key while opening database, do not work.
How can I unlock database so I can modify reports?
Any assistance would be much appreciated.
KJ

[sierra7]

Hello,
My company has an access database 1997 (.mdb) ..

I tried shift key while opening database, do not work.
How can I unlock database so I can modify reports?
Any assistance would be much appreciated.
KJ

Hi
Sounds like "Allow By-Pass " has been set to false.

Try running this app and enter the path and filename of your database.

S7

[Kinnari]

[QUOTE=sierra7]Hi
Sounds like "Allow By-Pass " has been set to false.

Try running this app and enter the path and filename of your database.

Hello S7,
I am not savi on access database. can you please explain how to run app to enter the path and filename?

Thanks again,

KJ

[sierra7]

Hi KJ

I think the problem was that the application I attached seems to have been lost! so I'll try again.

This is for Access 97. It needs to be unzipped into any folder. Double click from Windows explorer and it should open.

Type in the path to and name of your database file then click True or False to set/cancel Allow By Pass

S7