Thanks for your clear and helpful instructions. After following all the steps, however, I found that I could easily gain access to the encrypted back-end tables without the back-end password. (1) Create a new database. (2) Import the linked tables from the front-end database into the new database. This process also bypasses the security measures suggested for the front-end database (requiring login, disabling special keys, hiding the navigation pane, creating a new ribbon without the options button, disallowing full menus, and disallowing shortcut menus). Is there a way to prevent the importing of linked back-end tables from the front-end database into a new database?
Hi Steve. Your Advanced Access Videos are terrific! I've downloaded all of them and they help me out quite a bit.A quick question. I used the Northwind 2013 database to follow along in splitting the database. However, when I tried to use it as a front end in your Encrypting Your Data File I couldn't get it to encrypt as the database is saved as a "Signed Package". Do you know why this is?
Thanks for your video. I tried encrypting my back end but after encryption my front end file disappear and shows only the backstage view. Please help. Thanks.
Hello Steve! Thank you again for the great insight and all of your work! One thing, in Windows 10, there is no way in opening a file in Desktop Explorer to open it EXCLUSIVE or at least none which I could find. I did find a command to do it (took a while!). I have it as - "C:\Program Files (x86)\Microsoft Office\Office14\msaccess.exe" J:\Projects\Database\AtBuffalo,Inc_be.accdb /excl Perhaps this will help someone or if I could have done something else, let me know. Remember I am running Windows 10; not Windows 7.
Hi Steve, Thank you so much for this video. I would like to know that, instead of distributing frond end file as ACCDB, can't we use ACCDE file which will not enable the users to change anything. Can you please explain the difference between these two extensions accdb and accde. Thanks in advance
+Vijay Kumar That is exactly what I have done with my front end. However, I can only access the backend from the front end if the back end is not encrypted. My challenge is how to encrypt the back end and still have access from the front end without any problem. I have not been able to achieve that. I get "Run-time error '3031' : Not a valid password"
+Vijay Kumar ACCDE files compile the VBA code so that it cannot be viewed. It is still possible to get at tables, forms, queries, and reports in an ACCDE, but not the VBA code. To take full advantage of this I recommend following the steps in videos 58 and 59, along with using VBA recordsets and not linking any tables in your database. Use the VBA Recordsets to go retrieve the data since you can compile that code and make it inaccessible to those who you distribute your application to. If you send them the ACCDB file, then you are sending them everything and they will likely find a way around your security measures.
Hi Steve. after doing exercise 57, the be is no longer accessible in my microsoft access 2013 version. I am not sure if I missed something. I already did the exercise twice. The be icon as a ribbon like icon stamped to the be icon. Any idea what is it? thanks.
Thanks for the video. I did the encryption as you suggested, however, users have a shortcut they use to access the front end database and when they click to open the front end, the forms do not populate with data from the backend. Instead they get blank forms and some don't see the forms at all. I did go through and make sure that I deleted and re-linked the tables as you stated. Any ideas as to what is going on?
+MeeMee EmeeEme Make sure the file location is also correct when it's on their systems. If the front end cannot locate the back end file it can lead to issues like this.
No, I don't have a book or website. However I can tell you that www.functionx.com is one of my favorite resources and helped me out a lot while I was learning.
Hi Steve, First of all thanks for all your great videos! I however have an embarrassing question. I wanted to try and lock the access (Access 2016) database which was successful. However, I before ticked the option that requires the user to press shift when opening the file to see the options list. Now my problem is that Access asks for password to open the database(which I know) but I can't keep the shift button pressed when opening. In other words, I can't find a way to open the Database and see the navigation pane and options list. What would you recommend me to do? Your advice would really be helpful!
i set a password to my back end , but after thay it is impossible to open front end. When i dbl click on file it access (2013) starts but stop in stage where i can select templates
I assume VBA code that accesses these tables in the backend would have to be edited to include this password any time you need to access a table. Correct?
Hello, thank you very much for this video. I have a question. I would like to protect my data (tables) by encrypting the back end file, just like you explained. However, when I open the front end file, I'm not able to see any data related to the back end (e.g. list boxes don't show any values or combo boxes ask for password in order to use them). So, how can I protect my back end file and still be able to use the front end file?
+Programming Yes, I did. I noticed that after entering the password, the tables are unlocked in the front end but still locked in the back end. To protect the tables in the front end, I must follow what you did in the video. However, without unchecking the "Allow special keys" option, the navigation pane can be activated by pressing F11. Thank you for your response!
@@ProgrammingMadeEZ Thanks for replying and please don't take my comment as criticism. I think your SERIES on Access is probably the best I have seen (on any subject) on UA-cam. You go into the detail and while it slows down the individual tutorials it is absolutely necessary. I would never have imagined Custom Events for example until you showed they existed, how to create and implement them. I began playing with Access because Microsoft refused to develop a 64 bit version of Foxpro and it died. I have now come to realize that Access is a feature rich development environment capable of robust application development. Thanks for your series. The Assembler G that I started programming with 50 years ago is light years from what's available today.
Hi Steve, I had to remove uSysRibbon from my unsplit db before I could encrypt with password, and everything is fine. Do I need to add uSysRibbon back to my db if I am not creating a custom ribbon?
Thanks for all these free videos, I will watch them all, Br Leif Musset froms The Dominican Republic
Hi Bishop How could a report large text arrange as justify Text. please would you make video on it.
But, ... will the user be able to ADD data when only "read" permission is applied?
Thanks for your clear and helpful instructions. After following all the steps, however, I found that I could easily gain access to the encrypted back-end tables without the back-end password. (1) Create a new database. (2) Import the linked tables from the front-end database into the new database. This process also bypasses the security measures suggested for the front-end database (requiring login, disabling special keys, hiding the navigation pane, creating a new ribbon without the options button, disallowing full menus, and disallowing shortcut menus). Is there a way to prevent the importing of linked back-end tables from the front-end database into a new database?
I find encrypting the back end adds a hefty performance penalty - is there a better way?
Steve, why not just set the Read-only flag on the General tab?
Hi Steve. Your Advanced Access Videos are terrific! I've downloaded all of them and they help me out quite a bit.A quick question. I used the Northwind 2013 database to follow along in splitting the database. However, when I tried to use it as a front end in your Encrypting Your Data File I couldn't get it to encrypt as the database is saved as a "Signed Package". Do you know why this is?
Also, what about changing the file extension to accde? Is this done manually or is it not necessary?
Thanks for your video.
I tried encrypting my back end but after encryption my front end file disappear and shows only the backstage view. Please help.
Thanks.
MARVIN VILLAREAL I don't know what you mean by "backstage view".
Hello Steve! Thank you again for the great insight and all of your work!
One thing, in Windows 10, there is no way in opening a file in Desktop Explorer to open it EXCLUSIVE or at least none which I could find. I did find a command to do it (took a while!). I have it as -
"C:\Program Files (x86)\Microsoft Office\Office14\msaccess.exe" J:\Projects\Database\AtBuffalo,Inc_be.accdb /excl
Perhaps this will help someone or if I could have done something else, let me know. Remember I am running Windows 10; not Windows 7.
Hi Steve, Thank you so much for this video. I would like to know that, instead of distributing frond end file as ACCDB, can't we use ACCDE file which will not enable the users to change anything. Can you please explain the difference between these two extensions accdb and accde. Thanks in advance
+Vijay Kumar That is exactly what I have done with my front end. However, I can only access the backend from the front end if the back end is not encrypted.
My challenge is how to encrypt the back end and still have access from the front end without any problem. I have not been able to achieve that. I get "Run-time error '3031' : Not a valid password"
+Vijay Kumar ACCDE files compile the VBA code so that it cannot be viewed. It is still possible to get at tables, forms, queries, and reports in an ACCDE, but not the VBA code. To take full advantage of this I recommend following the steps in videos 58 and 59, along with using VBA recordsets and not linking any tables in your database. Use the VBA Recordsets to go retrieve the data since you can compile that code and make it inaccessible to those who you distribute your application to. If you send them the ACCDB file, then you are sending them everything and they will likely find a way around your security measures.
Thank you Steve :)
I forgot my database password, how can I recover it? please help .. Thanks
Hi Steve. after doing exercise 57, the be is no longer accessible in my microsoft access 2013 version. I am not sure if I missed something. I already did the exercise twice. The be icon as a ribbon like icon stamped to the be icon. Any idea what is it? thanks.
I tried using the manual way of connecting. This works so far.
Hi Steave, this video also very informative. rally helpful
Thanks for the video. I did the encryption as you suggested, however, users have a shortcut they use to access the front end database and when they click to open the front end, the forms do not populate with data from the backend. Instead they get blank forms and some don't see the forms at all. I did go through and make sure that I deleted and re-linked the tables as you stated. Any ideas as to what is going on?
+MeeMee EmeeEme Make sure the file location is also correct when it's on their systems. If the front end cannot locate the back end file it can lead to issues like this.
Hi, just great video's, do you have any web page or book also available to learn access vba.
Thank you and regards,
Janez
No, I don't have a book or website. However I can tell you that www.functionx.com is one of my favorite resources and helped me out a lot while I was learning.
Hi Steve, First of all thanks for all your great videos! I however have an embarrassing question. I wanted to try and lock the access (Access 2016) database which was successful. However, I before ticked the option that requires the user to press shift when opening the file to see the options list. Now my problem is that Access asks for password to open the database(which I know) but I can't keep the shift button pressed when opening. In other words, I can't find a way to open the Database and see the navigation pane and options list. What would you recommend me to do? Your advice would really be helpful!
You must have turned off the bypass key. You can try creating a new Access database, then import all of the forms, queries, tables, etc.
Hi, Thank you very much for the video, Now, I would like to send a report via Email as a PDF file can I encrypt the PDF file?
You would need to use a 3rd party tool to encrypt a file.
Hi Steve, how to prevent the deletion of be and fe file from the folder with full permisions? Smbd can find this folder and delete files from it...
That can only be handled by your admin setting permissions on the folder for your users.
i set a password to my back end , but after thay it is impossible to open front end. When i dbl click on file it access (2013) starts but stop in stage where i can select templates
p.s. After i remove password from my back end everything fine
Sounds like you need to changes the linked tables to use the password.
Programming
Ok, but front end is impossible to open.
Maybe there is problem with ribbon name that is set due to other user cant get to options?
I assume VBA code that accesses these tables in the backend would have to be edited to include this password any time you need to access a table. Correct?
Hello, thank you very much for this video. I have a question. I would like to protect my data (tables) by encrypting the back end file, just like you explained. However, when I open the front end file, I'm not able to see any data related to the back end (e.g. list boxes don't show any values or combo boxes ask for password in order to use them). So, how can I protect my back end file and still be able to use the front end file?
+Andrés Auvert Did you relink your tables on your front end?
+Programming Yes, I did. I noticed that after entering the password, the tables are unlocked in the front end but still locked in the back end. To protect the tables in the front end, I must follow what you did in the video. However, without unchecking the "Allow special keys" option, the navigation pane can be activated by pressing F11. Thank you for your response!
Hi, can u plz help out with DATA IMPORT in backend file while someone already open frontend file in other system?
Adding a password is NOT encrypting the data file.
True. They just prevent access to it and the data can't be read by just opening it in a notepad.
@@ProgrammingMadeEZ Thanks for replying and please don't take my comment as criticism. I think your SERIES on Access is probably the best I have seen (on any subject) on UA-cam. You go into the detail and while it slows down the individual tutorials it is absolutely necessary. I would never have imagined Custom Events for example until you showed they existed, how to create and implement them. I began playing with Access because Microsoft refused to develop a 64 bit version of Foxpro and it died. I have now come to realize that Access is a feature rich development environment capable of robust application development. Thanks for your series. The Assembler G that I started programming with 50 years ago is light years from what's available today.
Great!
Hi Steve,
I had to remove uSysRibbon from my unsplit db before I could encrypt with password, and everything is fine. Do I need to add uSysRibbon back to my db if I am not creating a custom ribbon?
No. If you don't plan on having a custom ribbon, there is no need for the USysRibbon table.
Thank you.
Don't write the password down. Js