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?

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
 
Back
Top