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

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).
Patrick O'DeaAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
in a2010, to convert to .accde or .mde

File> save & publish > make accde
or

File> save & publish > make mde
0
 
Rey Obrero (Capricorn1)Commented:
convert your .accdb to .accde, database tools > make accde

if .mdb convert to .mde  
0
 
Rey Obrero (Capricorn1)Commented:
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
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
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
 
Rey Obrero (Capricorn1)Commented:
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
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPConnect With a Mentor Commented:
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
 
Patrick O'DeaAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Yes
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
Patrick O'DeaAuthor Commented:
thanks all
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.