A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Any way to disable TABLES tab?



 
 
Thread Tools Display Modes
  #1  
Old December 14th, 2005, 10:43 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Any way to disable TABLES tab?

I created a custom front end for my user to create queries and reports. It
contains links to the production tables. I want to prevent the user looking
at the tables via the TABLES tab. I only want the user to look at data via
queries. Is there any way to do this without having to set up user-level
security?
  #2  
Old December 15th, 2005, 07:54 PM
Bob Miller Bob Miller is offline
Senior Member
 
First recorded activity by OfficeFrustration: May 2005
Posts: 358
Default

Hide them. Set their properties to hidden and then on the View tab in Options, uncheck the Hidden box.

Quote:
Originally Posted by mscertified
I created a custom front end for my user to create queries and reports. It
contains links to the production tables. I want to prevent the user looking
at the tables via the TABLES tab. I only want the user to look at data via
queries. Is there any way to do this without having to set up user-level
security?
  #3  
Old December 15th, 2005, 10:41 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Any way to disable TABLES tab?

I'm doing that but the user can easily unhide them. I'd really like to
disable the Tables tab in the designer....

"TedMi" wrote:

You don't need to rename them. On the Tables window, right-click the table,
choose properties, and check Hidden in the Attributes section.
--
Ted

  #4  
Old December 16th, 2005, 12:35 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Any way to disable TABLES tab?

Sorry, but it's not possible.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"mscertified" wrote in message
...
I'm doing that but the user can easily unhide them. I'd really like to
disable the Tables tab in the designer....

"TedMi" wrote:

You don't need to rename them. On the Tables window, right-click the
table,
choose properties, and check Hidden in the Attributes section.
--
Ted



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
EXPORTING OR IMPORTING TABLES Tom Database Design 8 November 8th, 2005 02:19 PM
Identifying Tables And Queries Used in Reporting Code Alok Joshi Setting Up & Running Reports 1 September 23rd, 2005 09:25 PM
Many to many reationship design? Dave Database Design 4 January 18th, 2005 11:11 PM
Need help linking 2 tables for entering new & editing existing rec scott General Discussion 2 January 18th, 2005 10:09 PM
Tables used during development rpw New Users 6 July 1st, 2004 01:29 AM


All times are GMT +1. The time now is 12:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.