• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

Making a accde file in Access 2007

What is the advantage of making a accde file database?
Thanks, Pat
0
PatKung
Asked:
PatKung
  • 6
  • 2
  • 2
4 Solutions
 
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
 
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)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
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
jmoss111Commented:
Nor does it prevent queries from being modified.

Regards,

Jim
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now