Prev: cancel
Next: Stopping a macro based Setwarning diag box
From: Emma Hope on 6 Apr 2010 11:35
I have a number of end users with Office 2007 and a number with Office 2003.

I am using Office 2007 at the moment but have access to a machine with
Office 2003 if needed. I am still trying to get the hang of Office 2007.

In Access 2003, you could turn off the Database Window as part of the
startup options so the end user could not see it. How do you do the
equivalent in Access 2007, i don't want my end users to see the tables and
queries etc.

I want them to see the nice form i have spent hours designing for them.
Therefore can someone explain to me how to turn off the 'database
window/navigation pane' for my end users who use both Access 2003 & Access
2007.

Thanks
Emma

From: Dirk Goldgar on 6 Apr 2010 12:27
"Emma Hope" <EmmaHope(a)discussions.microsoft.com> wrote in message
news:620FB841-BF1C-49E8-81A3-9616DF40355F(a)microsoft.com...
>I have a number of end users with Office 2007 and a number with Office
>2003.
>
> I am using Office 2007 at the moment but have access to a machine with
> Office 2003 if needed. I am still trying to get the hang of Office 2007.
>
> In Access 2003, you could turn off the Database Window as part of the
> startup options so the end user could not see it. How do you do the
> equivalent in Access 2007, i don't want my end users to see the tables and
> queries etc.
>
> I want them to see the nice form i have spent hours designing for them.
> Therefore can someone explain to me how to turn off the 'database
> window/navigation pane' for my end users who use both Access 2003 & Access
> 2007.


Office Button -> Access Options -> Current Database -> uncheck "Display
Navigation Pane"

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

From: Stephen Raftery on 6 Apr 2010 12:30
Go to the Options menu/Current database/Navigation pane, and uncheck it.

Stephen


"Emma Hope" wrote:

> I have a number of end users with Office 2007 and a number with Office 2003.
>
> I am using Office 2007 at the moment but have access to a machine with
> Office 2003 if needed. I am still trying to get the hang of Office 2007.
>
> In Access 2003, you could turn off the Database Window as part of the
> startup options so the end user could not see it. How do you do the
> equivalent in Access 2007, i don't want my end users to see the tables and
> queries etc.
>
> I want them to see the nice form i have spent hours designing for them.
> Therefore can someone explain to me how to turn off the 'database
> window/navigation pane' for my end users who use both Access 2003 & Access
> 2007.
>
> Thanks
> Emma
>
 | 
Pages: 1
Prev: cancel
Next: Stopping a macro based Setwarning diag box