how to stop Display navigation pane in access 2010

[Ruzz2k]

Hi i am running some code from vba to add a linked table and the do some lookups, then delete the linked tables.

When the linked table gets added, the navigation pane gets displayed. I have set it to do not display in the settings and it does not when it opens but when this code runs it opens and then stays open until the db is closed and reopened.

I am trying to use my db as a software and I really do not want this to show.
I have also noticed this in a database I have which has update queries and was fine in access 2000 but does what i described above when using in access 2010.

Is there any way to stop this thanks.

 

[Rx_]

Just to verify, in the Access Options - Current Database - are the check boxes UN-Checked for Enable Layout View, Enable Design changes for tables in Datasheet view, Display Navigation Pane...
I use Access 2010 with Linked Tables. My linked tables use code to create them as DSNLess http://www.access-programmers.co.uk/forums/showthread.php?t=224121&highlight=DSNless

Was the Access 2000 database just opened with Access 2010? This caused me some strange problems. Most of those problems went away when a new blank Access 2010 database was created - and then all of the Access 2000 objects were imported into it. Be sure to set up the Start Form and the other options the same.

Once in a while, something acts strange on the Access 2010. This is most likely due to the horrible latency on the local network in my environment. It is worth creating a new Access 2010 (blank) database on the local hard drive, and importing all objects into it (from the local hard drive). The added benefit is that it will really compress the DB in a way the Compact and Repair doesn't.

It is like eating Chicken Soup when you have a cold.... "it couldn't hurt".

 

[Ruzz2k]

Hi, I converted the DB to access 2010 and ensured the options are as you stated but it still happens.

found nothing rgearding this in a google search either

Confusing?