Bobby Heid
bheid at sc.rr.com
Sun Mar 9 18:57:33 CDT 2008
I do not have an answer to your question. But did you try holding down the shift key when you open the database? It's possible the code is doing something with the navigation pane. Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele Sent: Sunday, March 09, 2008 7:48 PM To: accessd at databaseadvisors.com Subject: [AccessD] Access 2007 Navigation Pane problem Hello: I have an Access 2007 database which appears to have a permanently locked navigation pane. Issuing the command (per MS documentation) ' Docmd.LockNavigationPane = False' has no effect - in code, in a macro, or in the immediate window. This means I can't get into design view for any forms, queries, etc. Makes it a little bit hard to modify :( The db was converted from Access 2003 .mdb format to Access 2007 .accdb; compiles OK and runs fine. When I create a db from scratch in Access 2007 it doesn't have this problem. Any suggestions? Thanks, Doug Steele