1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

how can i prevent read-only users from seeing the database window in access?

Discussion in 'Business Applications' started by bluebloods, Apr 7, 2005.

Thread Status:
Not open for further replies.
  1. bluebloods

    bluebloods Thread Starter

    Joined:
    Oct 2, 2004
    Messages:
    209
    ive set it up so that when a user logs on they dont see the database window(the one which show all the tables, queries etc.) they only see the switchboard.
    but all they have to do is click on the tab on the toolbar on the bottom for it to reappear :eek:

    how can i prevent this from happening?
     
  2. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    One simple way is in Tools\startup you can disable various toolbars. The draw back is if you hold down the shiftkey when dbl click to open you open in 'design mode'. But average user doesn't know.
     
  3. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Control the display of the Database window
    You can change the settings that determine whether the Database window is displayed when a Microsoft Access file opens. If you hide the Database window, you need to display a startup form or data access page so that others can navigate in your application.

    On the Tools menu, click Startup.
    Do one or more of the following:
    To display or hide the Database window when a Microsoft Access database or Microsoft Access project opens, clear or select the Display Database Window check box.

    To prevent or allow users from displaying the Database window by pressing F11, clear or select the Use Access Special Keys check box.

    If you have cleared both the Use Access Special Keys check box and the Display Database Window check box, replace the File menu with your own custom menu. This prevents the Database window from appearing when users repeatedly open the same Access file from the list of most recently used files.
    Notes

    Changes to these settings in the Startup dialog box won't take effect until the next time the Access file is opened.

    The Northwind sample database has a Main Switchboard form — an example of a form you might use to control navigation in your Access file. To view this form, open the Northwind database in your Microsoft Office folder's Samples folder. Click Forms under Objects in the Database window, click Main Switchboard, and then click the Open button on the Database window toolbar.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/350501

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice