accde This is a topic that many people are looking for. newyorkcityvoices.org is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, newyorkcityvoices.org would like to introduce to you Access 2007: Convert Database To ACCDE For Added Protection. Following along are instructions in the video below:
“For added protection to your access database files. You may want to consider converting them them from the default extension. Accdb or access database into ac. Cde.
First of all are extensions well extensions. Is what tells the operating system. What program. You should open up that file in in fact.
Let me come down. Here and maximize the exercise folder. Every time you save a file like in the word..
2007. Program or excel or access. You give it a name right. We ve got a ccd protection.
And what it does is it adds a dot and then everything to the right of that dot is the extension or it tells the operating system in this case windows vista what program this file should open up in it should open up as a word document not as excel not as access so without that extension. It becomes lost and it says. Oh my gosh. What program should you open this up in this file.
Now if you want to learn more about this you want to watch my windows vista level 1 training video assuming that you understand what i m talking about we ll go ahead and minimize this and let you know that converting it into an ac cd file will protect your database from somebody else copying the application including the supporting codes and modifications to the designs of forms and reports. Which is pretty nice in addition to that it prevents users from viewing modifying or creating forms reports and modules in design view. It also prevents them from adding deleting or changing references to database or object libraries prevents from changing source code and prevents them from importing or exporting forms reports or code..
Modules then you got some additional benefits it reduces the size of the database. So it s smaller it optimizes the memory usage and improves performance. So it s a little bit faster. It protects the vba code from being viewed or edited.
While allowing it to run and then it allows users update data to run reports without providing the entire database now you can add on top of all that also a password so to convert this let me maximize my access database. The first thing i may want to do is to assign the password and then go ahead and convert it so to assign in the password let me go ahead and go the office logo button close out because remember when it comes to assigning a password you have to open up the database in exclusive mode. If you watch the previous training video on password protection. So click on the office logo go to open select.
My database and then click on the open drop down arrow to exclusive come over to the database tools and then click on encrypt with password type in the password again to verify hit enter now. Let s go ahead and make this an ac cde file again. It s on the database tools tab to the database..
Tools group click on make ac cde. It s going to say okay. Where do you want to dump this file. We can say to the desktop and then click save.
And that s it now let s go ahead and close out of the database close out of the word document and there on my desktop. When i select it you can see integration. Dot acc de it s got a little protection there i m going to go ahead and double click to open it up first of all it s going to ask for the password. I m going to go ahead and type it in then once i m in the database.
Let s see if i can make any changes. I m going to go ahead and right click one of the forms. It locks me out from the design view..
So i can t see how it was designed let me come up here to the database. Tools and try to crack some code to the macro group and click on visual basic go ahead and try to expand these folders here and double click on one of the codes says project is unavailable. So it really locks you down. And prevents user from making a lot of changes to the vba code in the design view.
I recommend this for added protection definitely thanks for watching hey as a quick reminder. If you liked my video please give it a thumbs up you can also click on me and subscribe to my. Channel get notified of the latest videos and for only 200 a months you can have access to all my microsoft office training. ” .
Thank you for watching all the articles on the topic Access 2007: Convert Database To ACCDE For Added Protection. All shares of newyorkcityvoices.org are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.