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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
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 MVP, Access and Data Platform)Commented:
Yes
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
All Courses

From novice to tech pro — start learning today.