Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access 2010 - How do I ensure users cannot see tables, queries, VBA

Posted on 2011-03-15
10
Medium Priority
?
575 Views
Last Modified: 2012-06-27
Hi,

(I should know this ..but..)
I have a little database that I will be releasing to 2 or 3 users.
How do I make sure that these users will NOT be able to see raw tables, queries or VBA etc.

All the user should see is the forms and reports (with no design option).
0
Comment
Question by:Patrick O'Dea
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35142348
convert your .accdb to .accde, database tools > make accde

if .mdb convert to .mde  
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 668 total points
ID: 35142377
in a2010, to convert to .accde or .mde

File> save & publish > make accde
or

File> save & publish > make mde
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35142393
make sure that your application compiles before making .accde or .mde

from vba window Debug > compile ( there should be no error/s) before you can creata an accde,or mde file
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 668 total points
ID: 35142467
RE:
"How do I ensure users cannot see tables, queries, VBA"

Just noting that an ACCDE or MDE does not prevent users from seeing and/or changing table/query design and/or data.  It does prevent users from seeing Forms & Reports in design view, and they cannot view VBA code.

mx
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35142515
before you make an accde,
file >access options
current database
a. select a display form
b, uncheck display navigation pane
c. uncheck allow full menus
    uncheck default shrtcut menus  

    etc....

d. disable the bypass shift key
0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 664 total points
ID: 35142557
I agree that you should make an ACCDE/MDE.

Before you make an ACCDE/MDE you need to split your database into a front end and back end so that it is properly set up for multiple users.

Recommend reading: Splitting your Access database into application and data

I also run my applications (front ends) with Access in Runtime mode. This turns off the ability to enter into design mode on any object.

0
 

Author Comment

by:Patrick O'Dea
ID: 35142777
Thanks all,

If I do create a ACCDE then will this be runable by a user who has downloaded an Access "Runtime"??   (I.e. they do not have a full Access licence)
0
 
LVL 75
ID: 35142806
Yes
0
 
LVL 75
ID: 35142825
Well ... you have to create a Runtime installation ... but yes, and ACCDE with certainly work in the Runtime Environment.  You are responsible however for creating a custom menu /  navigation system, since the built-in menus / toolbars will not be present.

Runtime is a subject within itself ...

mx
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 35142845
thanks all
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question