Solved

How to make a exe file from access 2013 database

Posted on 2016-09-07
5
143 Views
Last Modified: 2016-09-20
I have a access database 2013 that i need to share with other people in the office but don't want anyone to change any setting.
I need them to change the content of some of the tables but not the settings or the layout. Is there a way i can give them access but have no menu tabs at top of the screen and only the main menu that i have setup. Cant I make the database in to an EXE file. any help would be great.
Thank you.
0
Comment
Question by:jodyreid
5 Comments
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
ID: 41788363
You cannot make the Access file into an .exe.  Executables are code only files.  Access databases are container files and contain many different kinds of objects.  Locking an Access app is a frequently asked question and the answer is - there is no absolute way.  This is a failing of Microsoft.  They think of an Access database as a document rather than an application and don't think we need this capability.  If we did, we would use a "real" application development tool.  What you can do to restrict access is a series of things that are fairly well documented.  I'm not going to repeat all the details because I know there are articles on EE that document this as well as many questions.

For starters, your application must use forms and reports to expose all application functionality as well as extensive error handling.  Only then can you start the lock down process and make very sure to make several backups so you can recover if you are too successful and manage to lock yourself out.

So, an overview.
1.  Use forms/reports/code to perform all application functions.
2.  Add robust error handling because once you lock the app down, if you run into an unhandled error, the app will simply shut down.
3.  Properly split the app so the users only open their own copy of the FE and never open a shared copy.  A simple distribution method is to use a .bat file run from a shortcut on the user's desktop.  The .bat file can copy the production copy of the FE to a local folder on the user's computer and open it from there.
4.  Set the AllowShiftBypass to no - there are many articles on this.  Be sure to read a couple.
5.  Compile the app to an .mde or .accde -- make ABSOLUTELY sure to backup the .mdb/.accdb because having to hire someone to reconstitute the source database results in a less than optimal solution.
6  The final step would be to rename the .accde to .accdr

Data is best protected by storing it in SQL Server rather than an .accdb.  If you use an .mdb/.accdb you must lock that file down also.  One simple trick though is to use an extension not related to Access so that double clicking on the database won't cause Access to try to open it.  You can still link to a file with a .bx4 extension, you just have to type in the file name.  Access won't present it to you in the file list.
0
 
LVL 19
ID: 41788378
if your users install RunTime, you can put an icon on their desktop that forces use of it by adding the  /runtime switch. There is also another extension you can use on the access database file (which I think Pat knows, so hopefully she will jump in and add another comment -- so I won't look it up) to use regular Access and limit accessibility

to answer your question, though, you can distribute an ACCDE or MDE to prevent design changes -- look in the options for SaveAs under the File menu
0
 
LVL 30

Expert Comment

by:hnasr
ID: 41789723
Search youtube for: How to Make MS Access Database Executable.

I did not try it, so your feedback will be helpful.
0
 
LVL 34

Expert Comment

by:PatHartman
ID: 41789803
hnasr, that video shows how to make an .accde which is a "compiled" version of the database it is NOT an executable.  All objects are still accessible in design view unless they contain code.  So, anyone can still change tables, queries, and macros but they cannot change forms, reports, and modules.  I put compiled in parentheses because VBA is not a compiled language.  It is an interpreted language and that is another reason that an Access app can never be an executable.  In an .accde, the source code is removed entirely and all that remains is p-code which is then interpreted at run time.
0
 

Author Closing Comment

by:jodyreid
ID: 41806793
Thank you.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
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…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

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

4 Experts available now in Live!

Get 1:1 Help Now