bcp5190
asked on
How to hide all tables.
How do i hide the tables?
I want to have update, delete, and insert permission from the form level. But i dont want any users to view or modify any tables. How do i do that in Access97.
How do i make distributed database so users can only view Forms.
I want to have update, delete, and insert permission from the form level. But i dont want any users to view or modify any tables. How do i do that in Access97.
How do i make distributed database so users can only view Forms.
A simple solution is to right click each table, choose properties, and then choose "hidden". This works fine for standard users, but expert ones will figure out how to set their options to show hidden tables.
ASKER
Yaaa, Even i can figure out how to unhide.
A 5 point question deserves a 5 point answer.
ASKER
I'm sorry, i don't mean to dicipoint you
One idea,
splitt the database into two:
1. one with the forms, reports, querys, macros and modules
2. one with only the tables.
by code you can create querys, and modify the records,...
the forms don't have recordsource, you put the recordsource on-line.
So you don't have to link the tables, only work a low level (by VBA).
PS. If you have problems with the points, please contact with the service customers, and they to tell you how to buy points.
I hope this help you.
splitt the database into two:
1. one with the forms, reports, querys, macros and modules
2. one with only the tables.
by code you can create querys, and modify the records,...
the forms don't have recordsource, you put the recordsource on-line.
So you don't have to link the tables, only work a low level (by VBA).
PS. If you have problems with the points, please contact with the service customers, and they to tell you how to buy points.
I hope this help you.
Use name of tables:
USYStable_name, where USYS (User System) - in all tables.
This works fine for standard
users, but expert ones will figure out how to set their options to show hidden tables.
USYStable_name, where USYS (User System) - in all tables.
This works fine for standard
users, but expert ones will figure out how to set their options to show hidden tables.
ASKER
Thank you arimsoft's
Would you please more specific with your answer
Would you please more specific with your answer
you can do what you want with user level security
The best way to prevent users from getting at your tables is to take away all permissions.
1) Remove permissions for Users Group and Admin User.
2) Create queries and set the queries "Run Permission" property to OWNERS.
3) Point the Form's Recordsource property to the Query.
Now users will not be able to get at the tables, but when they open the form, it will run the query. Since the query is designed to "borrow" you permissions, the query will be able to open the table.
1) Remove permissions for Users Group and Admin User.
2) Create queries and set the queries "Run Permission" property to OWNERS.
3) Point the Form's Recordsource property to the Query.
Now users will not be able to get at the tables, but when they open the form, it will run the query. Since the query is designed to "borrow" you permissions, the query will be able to open the table.
ASKER
If i remove the permission from group then no one can up date the tabel from form . There for i have give permission to group so member's of group can up date , insert or delete the table through from.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank You skor, I got your point