Problem opening database window in Access2003

[RogerC]

I am administrator of a database that was originally created by someone else in Access97. It opens to a form. The F11 key will not show the database window because the 'Use Access Special Keys' is disabled in Tools, Startup (to prevent users from opening the database window). This was not a problem in Access97 because holding down the shift key while opening the database caused it to open to the database window, not the form. The problem is, now that I have converted the database to Access2003, holding the shift-key down does not open the database to the database window. In other words, I have no way of opening the database window now. (I do have a copy of the 97 version). Does anyone know why the shift-key technique doesn't work in my Access2003 version of the database?

 

[lovemuscle2005]

The shift key can be disabled in 2003. Sounds like its locked up good and propper,

In this case I'd open a new database and import all your old database into it

 

[RogerC]

Thanks you lovemuscle2005. I will do as you suggest. However, I'm not quite sure what you mean by 'can be disabled'. Are you saying that it is always disabled in 2003, or I have done something to disable it? Can it be enabled?

 

[RogerC]

Does anyone know how to enable the shift key so that the database window will open upon opening the file?

 

[cstlaurent]

Using VBA from an other program, you can change the Allowbypasskey database property to true.


dim db as dao.database
set db = "path of the files"
db.properties("allowbypasskey") = true

good luck

 

[RogerC]

thanks cstlaurent, but I'm not exactly sure what you mean by 'using VBA from another program'. Can you explain this please?

 

[Andrew Fergus]

Have you considered removing the startup item in the original 97 version and re-converting the database? Is this possible?
My 2c
Andrew

 

[cstlaurent]

send me an e-mail at onetwo_75@hotmail.com I will send you an access 2003 file that will able you to set the property of allowshiftkey to true or false without oppening the file.

 

[RogerC]

Thank you cstlaurent... your method worked perfectly!