Thread: Disable Tables
View Single Post
  #1  
Old April 8th, 2010, 05:00 PM posted to microsoft.public.access.tablesdbdesign
shm135
external usenet poster
 
Posts: 26
Default Disable Tables

Hi,

I have a database which links to another database on the network. I
have linked 5 tables from database1 into database2. Users do not have
access to database2. Only I will have access.

Currently, users can not edit the design of the 5 tables, since they
are linked tables. However, they are able to open and view everything
in the tables. I would like to completely disable this. There are
queries which pull specific information for each user from these 5
tables and this is the only way that I would like users to view
information. I do not want them opening the original tables at all. Is
this possible? I would appreciate your help.

Thanks,
Sam