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.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
bcp5190Author Commented:
Yaaa, Even i can figure out how to unhide.
A 5 point question deserves a 5 point answer.
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

bcp5190Author Commented:
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.

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.  

bcp5190Author Commented:
Thank you arimsoft's
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.  
bcp5190Author Commented:
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.
You missed the point of my answer.  Look up the online help on Run Permissions.

Try this so you can see how it all works.

1) Create a table and a form.
2) Take away all permissions for your Users on the table.
3) Go to the Form's RecordSource Property and click the Build Button "..."  This will create a Query for your form.
4) In the query, include the fields you want to display and......
5) Set the Query's Run Permissions to OWNER.

Now when the users try to open the table directly, they will get No Permissions error, BUT, they can open the Form and have FULL access to the data.  In effect, they are borrowing your permissions via the query to get at the table.

Try it, you'll like it.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bcp5190Author Commented:
Thank You skor, I got your point
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.