Making a accde file in Access 2007

What is the advantage of making a accde file database?
Thanks, Pat
PatKungAsked:
Who is Participating?
 
jmoss111Commented:
Sorry, misread question...
An ACCDE file has the following benefits:
Reduces the size of the database.
Optimizes memory usage and improves performance.
Protects the VBA code from being viewed or edited while still allowing it to run.

An ACCDE file will not allow the user to:

View, modify, or create forms, reports, or modules in Design view.
Add, delete, or change references to databases or object libraries.
Change VBA code since there is no source code.
Import or export forms, reports, or code modules
0
 
jmoss111Commented:
Open the desired database, and on the Database Tools tab, in the Database Tools group, click Make ACCDE.

If necessary, in the Save As dialog box, navigate to the folder where you want to save the ACCDE file.

If necessary, in the File Name text box, rename the file.
Click Save to convert the Access database to an ACCDE file.

Open the ACCDE file and confirm that the conversion was successful.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Just noting that an accde  in no way protects the data in your tables from being seen and/or changed. Nor does it prevent queries from accessing data.

Be 100 % absolutely SURE that you always have the ACCDB master (multiple copies) available ... because it is very difficult in not impossible to get an ACCDE back to an ACCDB.

mx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
jmoss111Commented:
Nor does it prevent queries from being modified.

Regards,

Jim
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
oops ... I meant to say that.  Pretend that I did lol

mx
0
 
jmoss111Commented:
It looks like they should have given the ability to lock down querydefs, maybe only allowing code to modify the querydef.
0
 
PatKungAuthor Commented:
If the person you give the ACCDE file to does not have the same References set as are needed will the program bomb?
Thanks, Pat
0
 
jmoss111Commented:
Yes it will, and they either need to have Access or the runtime installed.
0
 
PatKungAuthor Commented:
Thanks guys!!
0
 
jmoss111Commented:
you're welcome, Pat Have a great day!

Jim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.