Solved

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

Posted on 2011-03-15
10
530 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

943 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

7 Experts available now in Live!

Get 1:1 Help Now