We help IT Professionals succeed at work.

Making a accde file in Access 2007

PatKung
PatKung asked
on
Medium Priority
261 Views
Last Modified: 2012-05-06
What is the advantage of making a accde file database?
Thanks, Pat
Comment
Watch Question

Commented:
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.
Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
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
Commented:
Nor does it prevent queries from being modified.

Regards,

Jim
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
oops ... I meant to say that.  Pretend that I did lol

mx

Commented:
It looks like they should have given the ability to lock down querydefs, maybe only allowing code to modify the querydef.

Author

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
Commented:
Yes it will, and they either need to have Access or the runtime installed.

Author

Commented:
Thanks guys!!

Commented:
you're welcome, Pat Have a great day!

Jim
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.