Solved

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

Posted on 2011-03-15
10
522 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
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 119

Expert Comment

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

if .mdb convert to .mde  
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 167 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 119

Expert Comment

by:Rey Obrero
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
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 167 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 119

Expert Comment

by:Rey Obrero
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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 166 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now