Access Beginner, Help...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I only need other users of my db to view one input form and not all
underlying tables and queries etc... Any ideas?
 
JohnC said:
I only need other users of my db to view one input form and not all
underlying tables and queries etc... Any ideas?
Click to expand...

Split the database into a back-end (data tables) and a front-end (queries,
forms, reports, code), linked to the back-end. It may be sufficient to
simply hide the database container, which you can do from the startup
options (Tools ... Startup). You can keep them from looking at the database
container:

http://www.mvps.org/access/modules/mdl0011.htm

You may need more than that, in which case you'll need to initiate
User-Level Security:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
You must log in or register to reply here.

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

CurrentUser issue 2
Subform not allowing data entry - not your typical case? 3
Need to get query results in a form field (Beginner with Access) 2
Use VBA to set form control to value in a non-master/child subform? 0
Form and Layout Views invisible - what else to try? 2
Excel Link Issue 1
Currenct issue with a text box 1
Executing a TableQur 1

Back
Top