asked on

How to make a exe file from access 2013 database

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.

ASKER CERTIFIED SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

crystal (strive4peace) - Microsoft MVP, Access

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

Hamed Nasr

Search youtube for: How to Make MS Access Database Executable.

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

PatHartman

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.

Jody Reid

ASKER

Thank you.