Hide menu options

P

Pam Coleman

In designing a database, is there a way to keep users from looking at tables,
if all I want them to have access to is their form.
 
R

Rick B

Yes. Take away their access.

To properly secure the database, you would take away the table access. You
would then build queries and base your forms on the queries. To make sure
the users can run the queries, you'd set them to "run with owner's
permission" in the query's property box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Crating User Form to Add Names 1
Sub projects added as read only in Master file which are saved on sharepoint 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Help creating a search form in Access XP 0
Weekly Report 2
Can't save my Office documents (after computer rebuild and reauthorization) 0
How do I clear a form? 0

Top