Access 2013 Navigation Pane will not expand

Question

I minimized the navigation pane as much as possible, not realizing that the handles would disappear in the process, and thereby making any attempt to expand the navigation pane, unsuccessful.  

Double clicking in the pane, hiding/showing the search box, hiding/showing the pane in options, all failed to bring back the handles or the pane back to a more manageable width.

Any suggestions?

Answer 1

Hi,

I tried to duplicate this, but I couldn't shrink it enough for it to disappear. It kept collapsing on its own before I get too narrow.

Is this by any chance a MDB file or maybe something upgraded from MDB?

Just curious...

Answer 2

I did compile it.  How would that affect the navigation pane? I am just starting with VBA so this is a learning experience.

Answer 3

Hi,

We're talking about the user interface, so I am not sure VBA would have anything to do with it. Rather than "compile," I think you meant to do a "compact and repair."

Just my 2 cents...

Answer 4

no I meant compile.  I had done several compact and repair during the development.  I recently went on line to find VBA code to create an audit trail, so after I added the module, I compiled the database.

Answer 5

Okay, yes, you are correctly referring to "compiling" the code. But as I said, compiling won't affect the Nav Pane because it has nothing to do with code or VBA since it's the user interface.

So, are you saying this is not a MDB (or an upgraded MDB) file?

Answer 6

as far as I know it is not

Answer 7

Okay, if importing all object to a new database container doesn't work, you may have to post a copy of your db for us to examine. But try exporting the objects to a new file first and let us know. Good luck!

Answer 8

working on import now.  Will let you know. Crossing my fingers!

Answer 9

i get another file with a .laccdb extension - record-locking information???? how do I get rid of that?

apart from that the import worked

Answer 10

Hi,

The locking file goes away when you close out of the database. If you close the database and the lock file is still there, you can try to delete it or open and close the db again.

Cheers!

Answer 11

will the lock file be a problem once I split the database? 

Answer 12

will the lock file be a problem once I split the database? 

The lock file is necessary for Access to keep track of users accessing the database. When you open the front end, a lock file will be created on your machine. When the front end tries to access the data in a linked table, a lock file will be created on the server for the backend. This is why all users with frontends need to have read, write, and modify permission to the backend folder.

So, to answer your question, it won't be a problem because creating the lock file is part of the design in Access to allow multiple users to access the same database file.

Hope it helps...

Answer 13

yes it does!  Thank you so much for your help!!! Have a great week!

Answer 14

Hi,

You're welcome! Good luck with your project.

Answer 15

Hi LyneBG,

in your last post you had mentioned that ,"yes it does!  Thank you so much for your help!!! Have a great week!".

it seems that your issue is solved and you got an Answer for your question.

if so then please try to mark the suggestion as an Answer given by .theDBguy.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 16

done!