Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things. Coffee With Steve: ua-cam.com/channels/eXAUvo5xxDY_b-lSknPC1A.html
Hi Steve, I'm trying to work on a project that requires building a student management system in access. I want to know where I should start with your videos (I've created the tables, forms, queries and I want to publish the database after creating a good front end) I'ed appreciate your help
Keep doing what you doing Steve. This guy is my goto for broadening my knowledge in Access and his tutorial is so easy to follow and he explains what the different function, variable, etc. does just so you know that you have that option. Highly Recommended.
Thanks for a high quality and truely professionally presented tutorial! I subscribed after watching only one, but I can see that I will be spending a lot of time on this channel!
Thank you for the wonderful video. So many videos skipped the AllowBypassKey option. Then the few tutorials I found for that option were not videos and did a poor job of telling how to insert their code so a nonprogrammer like me was having trouble using them. Your video was so easy to follow and then I just made backups before each step incase their was a bug in my code and the results was a nice secured database.
Thank you for very good presentation of access database learning. I see many videos of your and Richard sir. Very thankful for both of you. As a result I have created a desktop application accounting with GST for all India in access 2021. Thanks and obliged.
Thanks, Steve, great tips. I'm using Access as a front end for a cloud hosted MySQL db and want the Access layer to look, feel and act like a secure application. Your video will help a lot.
First of all, thanks for your awesome videos. I've watched a couple of tutorial series for access, and I can easily say this is by far the best one. Congratulations and thank you! My problem is that shift + open doesn't open my database in bypass mode. To be precise, i've only managed to open it in bypass mode like 4-5 times, and i'm stuck with this issue for like 30 minutes. Things i've checked so far: -Yes, i have chosen to turn on bypass (even made a second version without the bypass part in login form, so bypass was never turned off in this version). -Yes, my shift key is working. EDIT: checked it in another pc with access and it works fine (every time i shift + double-click, it opens in bypass if it is on). So, it must be something on my pc. EDIT: Also, forgot to mention that I used Access 2016, not 2013, to build my project, if that is important. I was wondering if there is some kind of trick regarding the use of "shift + open" (e.g. hold shift some seconds before clicking, use shift + double click instead of shift + enter or visa versa, etc). I know this may not be an access issue, but any idea why this is happenning would be a great help.
Be sure to hold the shift key down for the entire time the database is opening. If you let go before the database has performed all of it's startup then it will not work.
Hi Steave Thank you so much for your tutorials you are so good at explaining.I struggled whole day setting up xml finally it worked- (MS 2016)- here is the code friends
Raju, THANK YOU, THANK YOU, THANK YOU!!!! I could not find any errors in my code, and I checked 4 times and even had my wife check it. But still would not work. But the code you shared here, WORKED!!!! THANK YOU SO VERY, VERY MUCH!!!!
@@VicRauch45 Me either! However, when I hold he shift and open the database, it still doesn't show me the options in the File menu. Are you having this problem too?
@@itsamore382 No, I'm not having this problem. But I do my database a little different than what was suggested in the video. I have TWO copies of the same database. One is the one that I give to the users. It has EVERYTHING locked down so they can not get at anything. The other copy is mine and it is NOT locked down at all. Whenever changes or upgrades are done to the database, when it is ready for release to the users, the last thing I do is make a copy of the database, and then add all this "Lock It Down" code to the new copy, then release it to the users. But the origninal database without the lock-down code is still in my position, and the users have no access to it. This saves me from the problem of something going wrong within the lock-down code and making me very unhappy about having to completely re-write the entire database because I have locking myself out of it.
Hi, Steve. I note there is Quick Access Toolbar as a loophole for your coding here in which a user can still open Access Options by clicking More Commands... If Quick Access Toolbar is removed it will be perfect. I use MS Access 2010.
If you tried this code and the Shift+open did not enable the menus again, here is how I was able to get the menus back: There is a drop-down menu at the top left-hand corner (beside the Save icon, and the Undo and Redo icons). I clicked on that drop-down menu and selected "More Commands..." which allowed me to get to the "Current Database" settings. I was able to check "Display Navigation Pane", "Allow Full Menus" and "Allow Default Shortcut Menus".
Hi Jarrod, I am new to this and was having the same problem, however I followed your suggestion and it worked , but the problem the users will still have access to the "options" command, which will defeat the purpose of unchecking these boxes..i.e. that the users will not have access to the Options command thus preventing them from going into the database and making changes. Is there any other way to get the users to run the record.
Hi Claudette - Glad it worked for you. I'm on the same page as you - looking for a solution to both. I'll let you know if I find the final solution to both problems.
Thanks Steve!!! I have had the videos from Lynda, yet, yours were more interesting and helpful! I did have had a lot of issues with hiding the ribbon, QAT, and the buttons within file, but then after 2 days of searching, i found this: " DoCmd.ShowToolbar "Ribbon", acToolbarNo " (without quotation marks), add that to the Login form "On Load", and all options should disappear. And if you would still want to hide the options within "File", here is this little bit of code (Make a table named USysRibbons and put the following info in it like in the video): (Applies to office 2016)
Hi Bishop, Nice video, I have heard people saying that the Bypass can still be reversed using some kinda automation code. Hence the best method I thought of securing my code was by also having a VBA Password on the VBA Editor along with all the other wonderful methods which you demonstrated in your video. Thank you.
Thank you for the prompt reply, sorry for the confusion. What I meant is that when I tried to open the db file while holding down the shift key, it opened the db w/ full controls instead of just opening to the Login Screen as we want. I thought I fixed the problem as it seemed to work on first attempt; however, once I login and open it as Admin and then re-open it using the bypass (shift) key it seems that every subsequent attempt to open it w/ the shift key is successful in opening the db w/ full controls. So, I restarted my computer but that also didn't work. Not sure where I'm going wrong.
Bill Baird I had thought about that but I think I'll introduce accde a little later when we talk about distribution of software and bundling for commercial purposes.
Dear sir... question by Mr. Jarrod Parks is also important i found. Can u check please... below... details ... "If you tried this code and the Shift+open did not enable the menus again, here is how I was able to get the menus back: There is a drop-down menu at the top left-hand corner (beside the Save icon, and the Undo and Redo icons). I clicked on that drop-down menu and selected "More Commands..." which allowed me to get to the "Current Database" settings. I was able to check "Display Navigation Pane", "Allow Full Menus" and "Allow Default Shortcut Menus".
Dear Mr. Bishop,Thank you very much for the lessons and the code you provide in them!They are very usefull, easy to understand and fulfill.I faced some obstacles I passed trough and I woud like to share my solutions with people like me who are learning on their own.The first error I recieved was connected with setting property.It turns out that in an Visual Basic editor ->Tools->References->Microsoft DAO 3,6 objec library have to be checked.The other obstacle was connected with empty fields in login form.When you remain fields empty and press login button access returns an run-time error 94/Invalid use of Null/.I passed trough this by changing type of variables from String to Variant.I don`t know if it`s properly to apply but it does work for my project.Thank you very much again!
Thank you for your great tutorial video. But one thing I important thing I have found that if your database is encrypted with default MS Access database feature then this method won't work. To get this working you've have to decrypt the database by opening the database again with exclusive right. After that, I have found your "AllowbyPassKey" toggle setting working.
First off, as I have seen many people say in the comments that I have read so far, your tutorial videos are extremely useful and even more professional. Now to my inquiry; I have seen some code on some of of the videos that isn't explained that I think would be useful for me though I havent been able to find a video where you specifically talk about it. The code i am referring to is the Allow Bypass Key code. Is there a specific video that you could refer me to? Please and thanks in advance. Keep up the awesomeness!!!!!
Hmmm... I thought that's what I covered. From around 10:30 in the video I'm getting you ready to use the bypass key property, and around 12:55 I actually start to code it.
There is a loophole: The QAT is still available and commands can be accessed by customizing it. Even if it is hidden in code - if the file is renamed and the content security warning shows than it can be accessed again. The solution is to use "startFromScratch=true" - but that means you will need to build all the buttons that you want available on you own...
+Dan Klarman Thanks for the comment Dan. That's correct, I did not cover disabling the QAT and I probably should have looking back on it now. However if you save the file as an ACCDE file using the save as dialog within Access, it will not be accessible later even if you try renaming it.
I encountered a small problem with the vba allow Bypass Key code. Easily overcome in my situation by changing Dim prop As Property to Dim prop As DAO.Property After this change all worked as explained. I guess my vba library references differed from those of the video demo. Excellent and helpful video
Dear Mr. Bishop. How can we completely hide the ribbon (including File menu, and min, max, close buttons) so that the users should not be able to figure out the database has been developed in Ms Access. Thanks for the good work.
Hi Mr Steve I am new to programming and need your assistance. Ok, so I followed your steps and everything worked out fine. Great tutorials, Thank you very much. But my problem is I am unable to open the print Screen to make changes... such as Changing from Portrait to landscape etc. How can I accomplish this.
Hello Steve, all of this works perfectly fine when the macros are turned on. But when a new user downloads the front end to their desktop, the modal view of Login form doesn't allow them to enable macros. Is there a way around it? Thank you so much for all the videos again. They are a great tool for learning.
Hi Steve, I searched the comments before posting. What's the advantage of bypassing and re-loading. I thought you were going to have me set one ribbon or display based for user 1 and a different display for user 2. As in, different items would load automatically after login depending on employeetype_id. I'm guessing there's some smart reason you go this open and close route...??? curious so that if I go searching another way I know which is "better" / "more secure". thanks so so so much!
Hello, Just for FYI you know the AllowBypassKey can be changed remotely. So in another DB you can replace the CurrentDB with a reference set to the target DB and alter the setting as easily as you show it here. So a determined user could download a tool that does that very thing and turn it back on. I do this all the time with my DBs. I don't even have code in some to set this, because why would you need to if you can do it remotely, but again if you can anyone can. The code would look something like this: dim trgtDb as DAO Database Dim PathRef as String PathRef = "C:\blah\blah\NameYourDb.accdb" Set trgtDb = DBEngine.OpenDatabase(Name:=PathRef, Options:=False, ReadOnly:=False) trgtDB.Properties("AllowByPassKey") = [True/False] True : Next the time trgtDb is opened the bypass key will function. False: Next the time trgtDb is opened the bypass key will not function
Yes and ultimately the answer is to generate an accde file that is a binary executable that is compiled VBA rather than the ACCDB file which there will always be work arounds if you're really knowledgeable of.
Thank you so much Steve, I watched all the video series and all are great, in this video I have a problem, my XML code doesn't work it means that the option doesn't hide from my access. The version of my access is 2016, I also tried another code that I found for it but still have a problem. I'll be so thankful if you can guide my through that.
So, what should I do to make my Access file into a desktop program for windows so my colleagues can use it as a computer program? Thanks a lot in advance and thanks for a great video! Regards Falkson
Great set of teaching videos. Had written a DB for a Non-Profit and now need to secure it. I came across you Programming Tutorials in the nick of time. All was going well till.... saving the USysRibbons Table. Saves it ok but then it's gone. Can't locate it anywhere. Access lets me know when I re-set-up the table, I already have an object by the same name. Not a programmer, so how do I find it? Thanks for all the help in advance. CW (Again, great tutorial set.)
+Chuck W Found it. The web is great. Just need to use the exact wording to get there. Now there is the full access issue of the "Quick Access Tool Bar" with the little drop down, even though all other icon have been turned off or removed. Fixed that as well. DB ready for the Non-Profit. Thanks for the help. It made my volunteer DB designer days much shorter.
Hi Steve. I have been using your tutorials for my database and it has been a really good reference. I do have a problem in this section. I was able to get everything to work but I do see that you can right click the ribbon and go into customize mode and change the options from there. I did uncheck the "Allow Default Shortcut Menus" which should disable right click but I'm not sure if it will disable the right click I'm talking about. Are there any ways around this? Thanks.
Also, i found a security issue. The way the code is built, it allows access to almost everything: Since in the login form, the code was to first open the main menu and THEN close the login form, the control (focus) silently gets transfered to the navigation panel, so by tab & enter we can open whatever we want. Try it: Open the database, and after you click the login button, before you do anything/click anywhere, just press tab a couple of times and then press enter. I think that you understand that with appropriate number of tab presses, someone can open everything that's on the navigation panel. Solution: Invert the lines in the login form. First docmd.close the login form and then docmd.open the main menu. This way the main menu (or whatever form is opened) will have the focus, and the tab will navigate through the form's items instead of the navigation panel. Note: This may affect other forms as well, so make sure you check this kind of stuff when switching forms.
This will only work if you make the call to a module outside of the login form. Otherwise when you do a close of the form, that ends all VBA execution of the code on that form. I was not able to recreate the security vulnerability you described. I believe the main difference is that I do not have the navigation pane turned on in the database and therefor it cannot be tabbed to.
If "turned on" is different than "displayed", then you are probably right. Otherwise i don't know whyit didn't work for you. I followed your instructions from the video of the (current) login form, and then this video, and i noticed the above vulnerability. However, i haven't gone through your entire tutorial due to lack of time, so maybe you have make somewhere a change that prevents the vulnerability I found. Maybe I'll make a video to show the code and demonstrate it, so you can see exactly what happens.
Steve, I have written many programs using access and I like this video and need to get this to work. i just can't get this to work. I even tired the script from one of the subscribers below and still no luck. What might I have done wrong?
Hi Steve, Your videos have been a godsave as I am an ADBA and have been tasked creating a database. I am having a problem though. The error handling for appending the property doesn't seem to be working. I am getting the Run time error 3367 "cannot append. An object with that name already exist in the collection." It was working fine, but after I added the activity logging code I started getting the error. If I rem out the append statement when debugging then everything else works fine.
I think it should be added that to truly locked the frontend you need to distribute the application as an .accde. If the user has access to full Access it's not difficult to create an Access application that will open this database and set the properties to whatever they choose.
Hi Steve, Thank you for this lesson, it really solved an issue I had for a long time. One question though, if I Right Click on Any Form (after the front end was secured) I still have the "Design" option on the pop-up, which means that the user can still get hold of whatever is available in design mode. How can I disable only the "Design" option on the right click on the Forms?
I believe the 'Design View' in right-click context menu is controlled (enabled/disabled) by the "Allow Shortcuts Menu" in the File/Options/Current Database screen. This was addressed in the video, I believe. Check if Allow Shortcut Menu is disabled.
Hello Steve, I created the code as explain but, when I reopen the database options was still there. I would like to get this to work(:>).. Very Good videos !!!.
Thats a great video.. however, when you work for a .gov entity and the network guys require you to authenticate and enable macros on startup, the Login screen prevents you from enabling macros... this prevents code from running on startup.
Hi Steve! I have a question. If I split my DB but later I have to modify the forms or add more, how I do it??? And how I can upgrade the front end of the users?? Thank you very much for your videos and your effort. Cheers!!!!
aaron aaron aaron You really don't do anything different than if it was all one file except if you make a new table you have to link it to your front end. You may want to refresh your tables with the Linked Table Manager if you add or delete any columns from your back end database.
Steve, this series has been tremendously helpful, thank you. I do have a problem with this though, and I'm hoping you can help. I managed to get the routines developed through this tutorial to work w/ the help of the user comments provided herein. So, when I open the file w/out bypass key I am prompted by the login screen and can login as Admin and receive the bypass key prompt or as another user and be directed to the locked-down front end application. Great, everything working as expected up to this point! HOWEVER, I decided to test whether the bypass key would work at random and to my surprise it did. This is of course a problem b/c the database is not preventing the over-ride as we tried to implement through this routine. I checked and rechecked all steps and everything appears in order. I am a novice w/ code and am not sure at exactly which point things are failing. Any insight or help you can provide would be very much appreciated, thanks.
Hello Steve, Is there a ribbon can get rid of "tell me what you want to do?" and "quick access " of version 2016 and later. These two functions cause design leaking. Thanks a lot.
I just found your video on securing your front end … great work... Can you help.. I need to use checkboxes on a form to insert value into field when checked and clear value when unchecked . I'm using this VBA in the after_update of the chkbox If Chkbx1 = -1 Then Me.field1 = "text1" Else Me.field1 = Null End If two problems.. the box remains checked after leaving the record and if I return to that record and uncheck the box it does not clear the field .. Any help will be appreciated. ..Thank you
hi Steve. your video are very helpful. also I had a query on search button where after I search for a particular product I want the data to be populated in the textbox and not listbox. is it possible?
Hi Steve, thanks for your work. A quick question on your work file, how do I relink your tables on the backend to the front end, obviously I can't do it via the front end as the login requires the backend address for the table. Sorry still a bit new to this. Cheers.
Hi Bishop, First of all Thanks A LOT for this wonderful educational videos. Have seen many others over different subjects on different websites (included paid subscriptions), you manage to do superb job of explaining things. I have a question over this subject where locking down the database with the help of the code to disable the "shift" key. By me everything works fine and there is no problem with the functionality. My concern is; do you think if there would be a time although everything is working fine as it's current state, with an update on the Ms.Office Access software, we would be locked out from the database because they change something that interferes with the code that you supply? Please answer to this question if you see this post since this would be a major issue for me. I need to make a decision to compromise from the security in sake of usability. Thank you in advance!
The bypass key has been in Access since at least Access 97. Someone may be able to confirm it has existed since before then. I don't believe Microsoft has any intention of changing this. But there are also ways to get everything from this database if it were to be locked out. Even the system I provide is not fool proof. There are ways around it. There is really no such thing as a perfectly secure application, but if you're looking to build something nearer to impenetrable, you'll need to learn a different programming platform like .NET.
Thank you for the response! Really appreciated. I don't really need an ironclad database. I was just afraid on that issue (after update shift bypass conflict). Now that you gave me that info I feel more comfortable to make a sound decision (or advice the management accordingly). Thanks again!
No problem. Access is a great solution, and some of my clients use it in very large enterprise environments that cross the country. It is a viable option that often gets overlooked because Access has had a certain stigma against it in the programming community. Granted it isn't a full fledged programming platform like .NET, PHP, or Java. But if done properly it can do 95% of what those other platforms can do, and at the very least can incorporate class libraries from .NET so you CAN do those other things.
you have helped me so much! these work great! Thank you! What I cannot find is a way to manually change my table paths (the links from my front end to my back end) from an absolute path to a UNC address. Access won't let me. It's preventing me from sharing the database with users who are not on the same server but who can manually navigate to the server. I am at a loss. Does anyone know how to change the path for the tables without using the internal Access hunt and find feature?
You have to change the connection string on the tables. You can do this with VBA. Have a look here: stackoverflow.com/questions/12606326/linked-table-ms-access-2010-change-connection-string
hi there steve..i'd been following ur tutorial..its working great. but after a while, when i wanted to change and ade new query..its give me some error..i havent chose an object in new query but its show all the object on my table, yet i havent chosed them. is there anyway for me to reset all the setting in mydatabase option? please reply..thanks
Thank you for the great videos. It is greatly helpful. It seems that I can login with the user name only if I don't type anything in the password field! Did I miss something?
Chris I have really enjoyed your videos I have however tried the code for hiding the options bar but was unable to get it to work, I am currently using Access 2016 could this be the issue of why it does not want to work for me. Thanks in advance for any assistance
G'day, I have followed this and am an absolute novice, but when i save the USysRibbons table, it does not appear in my tables list. What is wrong? Thanks
Great tutorials - thanks for sharing your knowledge! I have a question regarding the AllowBypassKey property - I am running Access 2013 pro plus and can not get the space bar to bypass start up files. Is there some simple code I can insert in the immediate window that will check if the property exist and then display the current setting?
Ok I tried that and it actually did return an error. Said object was required or something to that affect. I used this > Debug.Print "-----> The database 'AllowBypassKey' property is set to: " & _ CurrentDb.Properties("AllowByPassKey") & "
Hi, sir Could you make a tutorial about secure a ms access database that prevent to be used in another computer, or make a license to prevent copy past the database, thanks for your kindness.
Very good tutorial and works well, unfortunately now that the database is locked I cannot do any mail merges, as all it will only allow me to see the Ribbon any ideas as to how to solve this issue?
Hi, Steve - this post was very helpful to me in securing a front end database. I used it in an application created in A2010 and everything worked fine. I just created a database in 2013, importing all the objects and I find now that the Privacy Options button is still visible even though the HTML (which I copied and pasted from your site) still has . Any ideas on the change of behavior? Thanks again for a very helpful post.
Hi sir thank you for sharing sir its helps me a lot. Yet, i am a beginner for access database designing. I did some access database but my concern was to restrict my database particular on distributing to some user that know the bypass key. Beside, your topic is fit to my concern. Regarding hiding option, i did it but i try to right click mouse button on file menu its appear customize ribbon which still can modify current database option. If possible sir we can restrict that or maybe i did some wrong. thank you
Hey, I have a problem. My primary from is a model from that maximizes when I open the access document. Now I did hide everything with the options in "Current database" tab. But now I'm not able to edit the file. The SHIFT+opening of the document doesn't work. Any idea on how to fix this?
Sounds like you forgot to add the reversal of the bypass key. If you followed along with the example you would have added the code that allows developers to turn the bypass key back on.
I'm having trouble with the Bypasskey coding for this video. I've went through the syntax several times, the only thing that I find different from your syntax and mine is that in the EmployeeType_ID table I'm using 1 instead of 3, its just my preference. However, when I try to login I receive a Microsoft Visual Basic window, with "Run-time error '424': Object required. I click on the debug option and it highlights the "If rs!EmployeeType_ID = 1 Then" syntax. Any thoughts?
Hi Steve, first of all thank you for these great videos ... I have followed your instructions and everything works except for the USysRibbons that is not making the "Otions" disappear ... I checked the code several time and it seems to be ok, any idea why it doesn't work? Thanks once again.
+Fabio Boccola Did you make sure to set it to be used? After making the table, you should save it, close the database and reopen the database. Then go to options and set the "Ribbon Name" option to your newly named "Default." Then close and open again and it should work.
For the bypass key section, why would you go through the trouble of creating a prop object, setting it to something, and then appending it to the Currentdb.Properties? Why not replace that whole thing with CurrentDb.Properties("AllowBypassKey") = False?
hi steve how about importing data from Access, they can access passwords and codes and easily enter all parts of the database.pls guide us if it passible
I found a way to turn the AllowBypassKey back on without opening the database. It helped me opening a database which was locked by accident! It is a simple tool available to every VBA programmer! If you like to know, tell me!
Open any database with a module and insert this code into a sub. Change the database name and execute: Dim db As Database Dim prpAllowBypassKey As Property Set db = OpenDatabase("C:\Temp\test.accdb") Set prpAllowBypassKey = db.Properties("AllowBypassKey") prpAllowBypassKey = True
Hello, thank you for your video. I have a question. If I login as a user with security level 3 and click Yes to turn on the Bypass key, do I have to turn it off again before closing the database? I followed what you did on the video, but when I click Yes and close the database, I can press the Shift key to bypass and when I close the database again, I can still do it. So I would have tu turn it off again, otherwise it would allow any user to press Shift and bypass if I don't turn it off. Do I have to sign in again and turn it off by clicking No?
Hi. Its nice code i got it working. For me need it to add bit extra on password check ("Or IsNull") other wize it was loking with empty Password Field. Not sure if it wasnt the issue for you. Thanks for shearing it ;)
Hi Steve, I've tried this with Access 2016(365) and it doesn't appear to work. The microsoft site it references to appears to have been removed. Do you have another video or information on how to do this with the current version of Access?
Hi Steve...I love your tutorials. I'm having a problem making this work. I create the USysRibbons table as instructed, close out and re-open the database, but in the current database options where I should select the ribbon name, there is nothing there to select. I have downloaded the work files but I cannot get into the FE database because the path to the BE database is steves_pc, and I cannot get into the front end using the shift bypass key because it was disabled in that tutorial. I can't even get to the point of evaluating the XML code I used in my database because I can't even get the ribbon to show up to select it in options.
Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things.
Coffee With Steve: ua-cam.com/channels/eXAUvo5xxDY_b-lSknPC1A.html
Hi Steve, I'm trying to work on a project that requires building a student management system in access. I want to know where I should start with your videos (I've created the tables, forms, queries and I want to publish the database after creating a good front end) I'ed appreciate your help
Pls help me I have done all that but when i am trying to bypass it with shift key it is not working btw thank you for your help greats vids
Keep doing what you doing Steve. This guy is my goto for broadening my knowledge in Access and his tutorial is so easy to follow and he explains what the different function, variable, etc. does just so you know that you have that option. Highly Recommended.
Your whole series is fantastic! Your explanations and examples are by far the best I've seen. Thanks so much for helping us out!
+Bob Thuli I am so glad you have found the videos helpful.
Great video! I started Access VBA programming by watching your videos. Thanks
Thanks for a high quality and truely professionally presented tutorial! I subscribed after watching only one, but I can see that I will be spending a lot of time on this channel!
Bruh! you must be liying! stop them drugs!\
Thank you for the wonderful video. So many videos skipped the AllowBypassKey option. Then the few tutorials I found for that option were not videos and did a poor job of telling how to insert their code so a nonprogrammer like me was having trouble using them. Your video was so easy to follow and then I just made backups before each step incase their was a bug in my code and the results was a nice secured database.
Thank you for very good presentation of access database learning. I see many videos of your and Richard sir. Very thankful for both of you. As a result I have created a desktop application accounting with GST for all India in access 2021.
Thanks and obliged.
Thanks, Steve, great tips. I'm using Access as a front end for a cloud hosted MySQL db and want the Access layer to look, feel and act like a secure application. Your video will help a lot.
man .. you amazing .. i had good experience in MS Access .. but with your videos now i get more and more .. thanks
First of all, thanks for your awesome videos. I've watched a couple of tutorial series for access, and I can easily say this is by far the best one. Congratulations and thank you!
My problem is that shift + open doesn't open my database in bypass mode. To be precise, i've only managed to open it in bypass mode like 4-5 times, and i'm stuck with this issue for like 30 minutes.
Things i've checked so far:
-Yes, i have chosen to turn on bypass (even made a second version without the bypass part in login form, so bypass was never turned off in this version).
-Yes, my shift key is working.
EDIT: checked it in another pc with access and it works fine (every time i shift + double-click, it opens in bypass if it is on). So, it must be something on my pc.
EDIT: Also, forgot to mention that I used Access 2016, not 2013, to build my project, if that is important.
I was wondering if there is some kind of trick regarding the use of "shift + open" (e.g. hold shift some seconds before clicking, use shift + double click instead of shift + enter or visa versa, etc).
I know this may not be an access issue, but any idea why this is happenning would be a great help.
Be sure to hold the shift key down for the entire time the database is opening. If you let go before the database has performed all of it's startup then it will not work.
You are right, now it works. Thank you SO much! It was getting very annoying.
Hi Steave Thank you so much for your tutorials you are so good at explaining.I struggled whole day setting up xml finally it worked- (MS 2016)- here is the code friends
Raju, THANK YOU, THANK YOU, THANK YOU!!!! I could not find any errors in my code, and I checked 4 times and even had my wife check it. But still would not work. But the code you shared here, WORKED!!!! THANK YOU SO VERY, VERY MUCH!!!!
@@VicRauch45 Me either! However, when I hold he shift and open the database, it still doesn't show me the options in the File menu. Are you having this problem too?
@@itsamore382 No, I'm not having this problem. But I do my database a little different than what was suggested in the video. I have TWO copies of the same database. One is the one that I give to the users. It has EVERYTHING locked down so they can not get at anything. The other copy is mine and it is NOT locked down at all. Whenever changes or upgrades are done to the database, when it is ready for release to the users, the last thing I do is make a copy of the database, and then add all this "Lock It Down" code to the new copy, then release it to the users. But the origninal database without the lock-down code is still in my position, and the users have no access to it. This saves me from the problem of something going wrong within the lock-down code and making me very unhappy about having to completely re-write the entire database because I have locking myself out of it.
Really thank you Author Raju Singh many thanks it is working
Thanks dear, i recommended this channel to my friends.
+Renjith Kuttichira Well thank you very much!
Hi, Steve. I note there is Quick Access Toolbar as a loophole for your coding here in which a user can still open Access Options by clicking More Commands... If Quick Access Toolbar is removed it will be perfect. I use MS Access 2010.
Thank you Mr.Steve for your easy to follow tutorial video.
If you tried this code and the Shift+open did not enable the menus again, here is how I was able to get the menus back: There is a drop-down menu at the top left-hand corner (beside the Save icon, and the Undo and Redo icons). I clicked on that drop-down menu and selected "More Commands..." which allowed me to get to the "Current Database" settings. I was able to check "Display Navigation Pane", "Allow Full Menus" and "Allow Default Shortcut Menus".
Hi Jarrod,
I am new to this and was having the same problem, however I followed your suggestion and it worked , but the problem the users will still have access to the "options" command, which will defeat the purpose of unchecking these boxes..i.e. that the users will not have access to the Options command thus preventing them from going into the database and making changes. Is there any other way to get the users to run the record.
Hi Claudette - Glad it worked for you. I'm on the same page as you - looking for a solution to both. I'll let you know if I find the final solution to both problems.
Thanks Jarrod, I'll let you know if I come up with something as well.
Thanks Steve!!! I have had the videos from Lynda, yet, yours were more interesting and helpful!
I did have had a lot of issues with hiding the ribbon, QAT, and the buttons within file, but then after 2 days of searching, i found this: " DoCmd.ShowToolbar "Ribbon", acToolbarNo " (without quotation marks), add that to the Login form "On Load", and all options should disappear.
And if you would still want to hide the options within "File", here is this little bit of code (Make a table named USysRibbons and put the following info in it like in the video): (Applies to office 2016)
Thanks, the code in the video didn't work. This one is working.
The weblink to schema is dead. We need to find the new one for this to work
Hi Bishop,
Nice video, I have heard people saying that the Bypass can still be reversed using some kinda automation code. Hence the best method I thought of securing my code was by also having a VBA Password on the VBA Editor along with all the other wonderful methods which you demonstrated in your video.
Thank you.
Thank you for the prompt reply, sorry for the confusion. What I meant is that when I tried to open the db file while holding down the shift key, it opened the db w/ full controls instead of just opening to the Login Screen as we want. I thought I fixed the problem as it seemed to work on first attempt; however, once I login and open it as Admin and then re-open it using the bypass (shift) key it seems that every subsequent attempt to open it w/ the shift key is successful in opening the db w/ full controls. So, I restarted my computer but that also didn't work. Not sure where I'm going wrong.
In other words, it does not over-ride the bypass key whereby the shift key continues to work despite the routine we build here.
Bill Baird I had thought about that but I think I'll introduce accde a little later when we talk about distribution of software and bundling for commercial purposes.
Dear sir... question by Mr. Jarrod Parks is also important i found. Can u check please... below... details
...
"If you tried this code and the Shift+open did not enable the menus again, here is how I was able to get the menus back: There is a drop-down menu at the top left-hand corner (beside the Save icon, and the Undo and Redo icons). I clicked on that drop-down menu and selected "More Commands..." which allowed me to get to the "Current Database" settings. I was able to check "Display Navigation Pane", "Allow Full Menus" and "Allow Default Shortcut Menus".
Dear Mr. Bishop,Thank you very much for the lessons and the code you provide in them!They are very usefull, easy to understand and fulfill.I faced some obstacles I passed trough and I woud like to share my solutions with people like me who are learning on their own.The first error I recieved was connected with setting property.It turns out that in an Visual Basic editor ->Tools->References->Microsoft DAO 3,6 objec library have to be checked.The other obstacle was connected with empty fields in login form.When you remain fields empty and press login button access returns an run-time error 94/Invalid use of Null/.I passed trough this by changing type of variables from String to Variant.I don`t know if it`s properly to apply but it does work for my project.Thank you very much again!
👍 Great, please let us know how we can get the Default Ribbon XML text, you mentioned!?🙏
Thank you for your great tutorial video.
But one thing I important thing I have found that if your database is encrypted with default MS Access database feature then this method won't work. To get this working you've have to decrypt the database by opening the database again with exclusive right. After that, I have found your "AllowbyPassKey" toggle setting working.
Thanks Steve, very much appreciated.
Keep the good work coming. 👌
First off, as I have seen many people say in the comments that I have read so far, your tutorial videos are extremely useful and even more professional. Now to my inquiry; I have seen some code on some of of the videos that isn't explained that I think would be useful for me though I havent been able to find a video where you specifically talk about it. The code i am referring to is the Allow Bypass Key code. Is there a specific video that you could refer me to? Please and thanks in advance.
Keep up the awesomeness!!!!!
Hmmm... I thought that's what I covered. From around 10:30 in the video I'm getting you ready to use the bypass key property, and around 12:55 I actually start to code it.
Wow. I cant believe i missed that. Ok Disregard my oversight. Thank you
Great video thank you. Question, do you need to even do this if you are using Ms Access runtime?
There is a loophole:
The QAT is still available and commands can be accessed by customizing it.
Even if it is hidden in code - if the file is renamed and the content security warning shows than it can be accessed again.
The solution is to use "startFromScratch=true" - but that means you will need to build all the buttons that you want available on you own...
+Dan Klarman Thanks for the comment Dan. That's correct, I did not cover disabling the QAT and I probably should have looking back on it now. However if you save the file as an ACCDE file using the save as dialog within Access, it will not be accessible later even if you try renaming it.
I encountered a small problem with the vba allow Bypass Key code. Easily overcome in my situation by changing
Dim prop As Property
to
Dim prop As DAO.Property
After this change all worked as explained.
I guess my vba library references differed from those of the video demo.
Excellent and helpful video
Thank you ActiveInventories! I appreciate your contribution as I'm sure others might run into the same problem.
Thanks so much for your tutilidge... Can you secure the back end in the same manner as the front end?
Great video again. Why can't you convert the db to accde format to distribute to client. Thank you
Dear Mr. Bishop. How can we completely hide the ribbon (including File menu, and min, max, close buttons) so that the users should not be able to figure out the database has been developed in Ms Access. Thanks for the good work.
You need a single line of code in the 'on load' section of your events for your main form.
Hi Mr Steve
I am new to programming and need your assistance.
Ok, so I followed your steps and everything worked out fine. Great tutorials, Thank you very much. But my problem is I am unable to open the print Screen to make changes... such as Changing from Portrait to landscape etc. How can I accomplish this.
this video is again EXACTLY what I needed. Thank you!!!!!!!!!!!
Man, you're the BEST!!! Thanks
Hello Steve, all of this works perfectly fine when the macros are turned on. But when a new user downloads the front end to their desktop, the modal view of Login form doesn't allow them to enable macros. Is there a way around it? Thank you so much for all the videos again. They are a great tool for learning.
Hi Steve, I searched the comments before posting. What's the advantage of bypassing and re-loading. I thought you were going to have me set one ribbon or display based for user 1 and a different display for user 2. As in, different items would load automatically after login depending on employeetype_id. I'm guessing there's some smart reason you go this open and close route...??? curious so that if I go searching another way I know which is "better" / "more secure". thanks so so so much!
Hello,
Just for FYI you know the AllowBypassKey can be changed remotely. So in another DB you can replace the CurrentDB with a reference set to the target DB and alter the setting as easily as you show it here. So a determined user could download a tool that does that very thing and turn it back on. I do this all the time with my DBs. I don't even have code in some to set this, because why would you need to if you can do it remotely, but again if you can anyone can.
The code would look something like this:
dim trgtDb as DAO Database
Dim PathRef as String
PathRef = "C:\blah\blah\NameYourDb.accdb"
Set trgtDb = DBEngine.OpenDatabase(Name:=PathRef, Options:=False, ReadOnly:=False)
trgtDB.Properties("AllowByPassKey") = [True/False]
True : Next the time trgtDb is opened the bypass key will function.
False: Next the time trgtDb is opened the bypass key will not function
Yes and ultimately the answer is to generate an accde file that is a binary executable that is compiled VBA rather than the ACCDB file which there will always be work arounds if you're really knowledgeable of.
Thank you so much Steve, I watched all the video series and all are great, in this video I have a problem, my XML code doesn't work it means that the option doesn't hide from my access. The version of my access is 2016, I also tried another code that I found for it but still have a problem. I'll be so thankful if you can guide my through that.
Same issue 😞
So, what should I do to make my Access file into a desktop program for windows so my colleagues can use it as a computer program?
Thanks a lot in advance and thanks for a great video!
Regards
Falkson
Great set of teaching videos. Had written a DB for a Non-Profit and now need to secure it. I came across you Programming Tutorials in the nick of time. All was going well till.... saving the USysRibbons Table. Saves it ok but then it's gone. Can't locate it anywhere. Access lets me know when I re-set-up the table, I already have an object by the same name. Not a programmer, so how do I find it? Thanks for all the help in advance. CW (Again, great tutorial set.)
+Chuck W Found it. The web is great. Just need to use the exact wording to get there. Now there is the full access issue of the "Quick Access Tool Bar" with the little drop down, even though all other icon have been turned off or removed. Fixed that as well. DB ready for the Non-Profit. Thanks for the help. It made my volunteer DB designer days much shorter.
Long live Steve, really you're great, best wishes, regards
Hi Steve. I have been using your tutorials for my database and it has been a really good reference. I do have a problem in this section. I was able to get everything to work but I do see that you can right click the ribbon and go into customize mode and change the options from there. I did uncheck the "Allow Default Shortcut Menus" which should disable right click but I'm not sure if it will disable the right click I'm talking about. Are there any ways around this? Thanks.
Excellent videos, The Ribbon XML code does not seem to work with Access 2016, Do you have a fix for this?
Also, i found a security issue. The way the code is built, it allows access to almost everything: Since in the login form, the code was to first open the main menu and THEN close the login form, the control (focus) silently gets transfered to the navigation panel, so by tab & enter we can open whatever we want. Try it: Open the database, and after you click the login button, before you do anything/click anywhere, just press tab a couple of times and then press enter. I think that you understand that with appropriate number of tab presses, someone can open everything that's on the navigation panel.
Solution: Invert the lines in the login form. First docmd.close the login form and then docmd.open the main menu. This way the main menu (or whatever form is opened) will have the focus, and the tab will navigate through the form's items instead of the navigation panel.
Note: This may affect other forms as well, so make sure you check this kind of stuff when switching forms.
This will only work if you make the call to a module outside of the login form. Otherwise when you do a close of the form, that ends all VBA execution of the code on that form.
I was not able to recreate the security vulnerability you described. I believe the main difference is that I do not have the navigation pane turned on in the database and therefor it cannot be tabbed to.
If "turned on" is different than "displayed", then you are probably right. Otherwise i don't know whyit didn't work for you. I followed your instructions from the video of the (current) login form, and then this video, and i noticed the above vulnerability. However, i haven't gone through your entire tutorial due to lack of time, so maybe you have make somewhere a change that prevents the vulnerability I found. Maybe I'll make a video to show the code and demonstrate it, so you can see exactly what happens.
Steve, I have written many programs using access and I like this video and need to get this to work. i just can't get this to work. I even tired the script from one of the subscribers below and still no luck. What might I have done wrong?
Pls help me I have done all that but when i am trying to bypass it with shift key it is not working
Hi Steve,
Your videos have been a godsave as I am an ADBA and have been tasked creating a database. I am having a problem though. The error handling for appending the property doesn't seem to be working. I am getting the Run time error 3367 "cannot append. An object with that name already exist in the collection." It was working fine, but after I added the activity logging code I started getting the error. If I rem out the append statement when debugging then everything else works fine.
do you have any video regarding pick and pack goods,
I think it should be added that to truly locked the frontend you need to distribute the application as an .accde. If the user has access to full Access it's not difficult to create an Access application that will open this database and set the properties to whatever they choose.
You are correct. I mention this in later videos, but it would have been appropriate to bring it up here.
Hi Steve, Thank you for this lesson, it really solved an issue I had for a long time. One question though, if I Right Click on Any Form (after the front end was secured) I still have the "Design" option on the pop-up, which means that the user can still get hold of whatever is available in design mode. How can I disable only the "Design" option on the right click on the Forms?
I believe the 'Design View' in right-click context menu is controlled (enabled/disabled) by the "Allow Shortcuts Menu" in the File/Options/Current Database screen. This was addressed in the video, I believe.
Check if Allow Shortcut Menu is disabled.
IF only i saw this video earlier. Thanks you for been generous like this
Hello Steve, I created the code as explain but, when I reopen the database options was still there. I would like to get this to work(:>).. Very Good videos !!!.
Thats a great video.. however, when you work for a .gov entity and the network guys require you to authenticate and enable macros on startup, the Login screen prevents you from enabling macros... this prevents code from running on startup.
Hi Steve! I have a question. If I split my DB but later I have to modify the forms or add more, how I do it??? And how I can upgrade the front end of the users??
Thank you very much for your videos and your effort. Cheers!!!!
aaron aaron aaron You really don't do anything different than if it was all one file except if you make a new table you have to link it to your front end. You may want to refresh your tables with the Linked Table Manager if you add or delete any columns from your back end database.
Steve, this series has been tremendously helpful, thank you.
I do have a problem with this though, and I'm hoping you can help. I managed to get the routines developed through this tutorial to work w/ the help of the user comments provided herein. So, when I open the file w/out bypass key I am prompted by the login screen and can login as Admin and receive the bypass key prompt or as another user and be directed to the locked-down front end application. Great, everything working as expected up to this point! HOWEVER, I decided to test whether the bypass key would work at random and to my surprise it did.
This is of course a problem b/c the database is not preventing the over-ride as we tried to implement through this routine. I checked and rechecked all steps and everything appears in order. I am a novice w/ code and am not sure at exactly which point things are failing. Any insight or help you can provide would be very much appreciated, thanks.
What do you mean you're checking the bypass key at random?
Hi Steve,
I want to know how you hide those first few database table options in your video? Plz explain.
Hello Steve, Is there a ribbon can get rid of "tell me what you want to do?" and "quick access " of version 2016 and later. These two functions cause design leaking. Thanks a lot.
I just found your video on securing your front end … great work... Can you help.. I need to use checkboxes on a form to insert value into field when checked and clear value when unchecked . I'm using this VBA in the after_update of the chkbox
If Chkbx1 = -1 Then
Me.field1 = "text1"
Else
Me.field1 = Null
End If
two problems.. the box remains checked after leaving the record and if I return to that record and uncheck the box it does not clear the field .. Any help will be appreciated. ..Thank you
hi Steve.
your video are very helpful.
also I had a query on search button
where after I search for a particular product I want the data to be populated in the textbox and not listbox.
is it possible?
Thank you! Very helpful.
Very neat and nice solution
+wcambris Thank you!
Hi Steve, thanks for your work. A quick question on your work file, how do I relink your tables on the backend to the front end, obviously I can't do it via the front end as the login requires the backend address for the table. Sorry still a bit new to this. Cheers.
Ok worked it out with a bit of trial and error, I imported both the front end and back end into a new database. Thanks again for your tutorials.
Hi! Steve, thank you for your great work. Is this code worked with MS Access 2007 version? Can we disable F11 key in vba?
Hi Bishop,
First of all Thanks A LOT for this wonderful educational videos. Have seen many others over different subjects on different websites (included paid subscriptions), you manage to do superb job of explaining things.
I have a question over this subject where locking down the database with the help of the code to disable the "shift" key. By me everything works fine and there is no problem with the functionality. My concern is; do you think if there would be a time although everything is working fine as it's current state, with an update on the Ms.Office Access software, we would be locked out from the database because they change something that interferes with the code that you supply? Please answer to this question if you see this post since this would be a major issue for me. I need to make a decision to compromise from the security in sake of usability. Thank you in advance!
The bypass key has been in Access since at least Access 97. Someone may be able to confirm it has existed since before then. I don't believe Microsoft has any intention of changing this. But there are also ways to get everything from this database if it were to be locked out. Even the system I provide is not fool proof. There are ways around it. There is really no such thing as a perfectly secure application, but if you're looking to build something nearer to impenetrable, you'll need to learn a different programming platform like .NET.
Thank you for the response! Really appreciated.
I don't really need an ironclad database. I was just afraid on that issue (after update shift bypass conflict). Now that you gave me that info I feel more comfortable to make a sound decision (or advice the management accordingly). Thanks again!
No problem. Access is a great solution, and some of my clients use it in very large enterprise environments that cross the country. It is a viable option that often gets overlooked because Access has had a certain stigma against it in the programming community. Granted it isn't a full fledged programming platform like .NET, PHP, or Java. But if done properly it can do 95% of what those other platforms can do, and at the very least can incorporate class libraries from .NET so you CAN do those other things.
Hello. Will the language you give in the data table to hide away privacy settings also worked with access 2016?
Excellent... I really appreciate you...
you have helped me so much! these work great! Thank you! What I cannot find is a way to manually change my table paths (the links from my front end to my back end) from an absolute path to a UNC address. Access won't let me. It's preventing me from sharing the database with users who are not on the same server but who can manually navigate to the server. I am at a loss. Does anyone know how to change the path for the tables without using the internal Access hunt and find feature?
You have to change the connection string on the tables. You can do this with VBA. Have a look here: stackoverflow.com/questions/12606326/linked-table-ms-access-2010-change-connection-string
hi there steve..i'd been following ur tutorial..its working great. but after a while, when i wanted to change and ade new query..its give me some error..i havent chose an object in new query but its show all the object on my table, yet i havent chosed them. is there anyway for me to reset all the setting in mydatabase option? please reply..thanks
Hi Steve, unfortunately it does not work in Microsoft 365. Does it work in Access 2016? Do you have the updated version?
Hi Steve can I disable shortcut menue for certain users and enable it for others? @Programming , +Programming
Thank you for the great videos. It is greatly helpful. It seems that I can login with the user name only if I don't type anything in the password field! Did I miss something?
Did the problem get resolved?
thank you very much
is there a way to disable quick access toolbar in print preview
Chris I have really enjoyed your videos I have however tried the code for hiding the options bar but was unable to get it to work, I am currently using Access 2016 could this be the issue of why it does not want to work for me. Thanks in advance for any assistance
Thank you so much for your help!
G'day,
I have followed this and am an absolute novice, but when i save the USysRibbons table, it does not appear in my tables list. What is wrong? Thanks
WoodyAus It is a hidden/system table. You have to change the Navigation Pane settings to show hidden and system tables.
Programming Many Thanks. This has done exactly what i require. Well done good work
Great tutorials - thanks for sharing your knowledge!
I have a question regarding the AllowBypassKey property - I am running Access 2013 pro plus and can not get the space bar to bypass start up files. Is there some simple code I can insert in the immediate window that will check if the property exist and then display the current setting?
Just do the CurrendDb.Properties("AllowBypassKey") = true. If this gives you an error then it's not the setting that's causing the problem.
Thank you I will give that a try.
Ok I tried that and it actually did return an error. Said object was required or something to that affect.
I used this >
Debug.Print "-----> The database 'AllowBypassKey' property is set to: " & _
CurrentDb.Properties("AllowByPassKey") & "
Heh.. I just realized. You're holding the spacebar. The bypass key is SHIFT. Hold the SHIFT key down.
OMG - WOW what an idiot I am! Thanks for hitting me with a brick, I deserved that.
Hi, sir
Could you make a tutorial about secure a ms access database that prevent to be used in another computer, or make a license to prevent copy past the database, thanks for your kindness.
Very good tutorial and works well, unfortunately now that the database is locked I cannot do any mail merges, as all it will only allow me to see the Ribbon any ideas as to how to solve this issue?
Sounds like your issue is specific to your database.
Do you have the no ribbon display code in a better readable display? Does this still work in Access 2016?
@Ezwah7, have you tried a compact and repair?
Yes, I did, and error messages keeps on appearing.
Hi, Steve - this post was very helpful to me in securing a front end database.
I used it in an application created in A2010 and everything worked fine.
I just created a database in 2013, importing all the objects and I find now that the Privacy Options button is still visible even though the HTML (which I copied and pasted from your site) still has .
Any ideas on the change of behavior?
Thanks again for a very helpful post.
+loge10 Try changing the "startfromscratch" to true.
+Programming Thanks for the suggestion but the Privacy Options button still shows.
Hmmm.. I'm not entirely sure what's missing then.
You're the best.
Hi sir thank you for sharing sir its helps me a lot. Yet, i am a beginner for access database designing. I did some access database but my concern was to restrict my database particular on distributing to some user that know the bypass key. Beside, your topic is fit to my concern. Regarding hiding option, i did it but i try to right click mouse button on file menu its appear customize ribbon which still can modify current database option. If possible sir we can restrict that or maybe i did some wrong. thank you
I'm sorry but I don't quite understand the problem.
This is brilliant. Thank you 😊
Hey, I have a problem. My primary from is a model from that maximizes when I open the access document. Now I did hide everything with the options in "Current database" tab. But now I'm not able to edit the file. The SHIFT+opening of the document doesn't work. Any idea on how to fix this?
Sounds like you forgot to add the reversal of the bypass key. If you followed along with the example you would have added the code that allows developers to turn the bypass key back on.
I'm having trouble with the Bypasskey coding for this video. I've went through the syntax several times, the only thing that I find different from your syntax and mine is that in the EmployeeType_ID table I'm using 1 instead of 3, its just my preference. However, when I try to login I receive a Microsoft Visual Basic window, with "Run-time error '424': Object required. I click on the debug option and it highlights the "If rs!EmployeeType_ID = 1 Then" syntax. Any thoughts?
Jared Ragland Did you look at the work files?
I took a look but didn't see anything for video 59, I might have looked over it though.
Jared Ragland I definitely recommend you look at it. You'll probably find the problem.
Steve, how important is that link to MS website? Since it seems that it is no longer available...
+Chris Wisselo you must include a namespace.
Hi Steve, first of all thank you for these great videos ... I have followed your instructions and everything works except for the USysRibbons that is not making the "Otions" disappear ... I checked the code several time and it seems to be ok, any idea why it doesn't work? Thanks once again.
+Fabio Boccola Did you make sure to set it to be used? After making the table, you should save it, close the database and reopen the database. Then go to options and set the "Ribbon Name" option to your newly named "Default." Then close and open again and it should work.
Go to File -> Options -> Current Database->click Navigation Options->check Show system options.
I hope this will help you
For the bypass key section, why would you go through the trouble of creating a prop object, setting it to something, and then appending it to the Currentdb.Properties? Why not replace that whole thing with CurrentDb.Properties("AllowBypassKey") = False?
Nubblet Because the property doesn't exist until you create it.
hi steve
how about importing data from Access, they can access passwords and codes and easily enter all parts of the database.pls guide us if it passible
I found a way to turn the AllowBypassKey back on without opening the database. It helped me opening a database which was locked by accident! It is a simple tool available to every VBA programmer! If you like to know, tell me!
Yes Please!
Open any database with a module and insert this code into a sub. Change the database name and execute:
Dim db As Database
Dim prpAllowBypassKey As Property
Set db = OpenDatabase("C:\Temp\test.accdb")
Set prpAllowBypassKey = db.Properties("AllowBypassKey")
prpAllowBypassKey = True
How can I turn off/hide the Quick Access Toolbar at the top left of the window? The options menu could be accessed using the QAT
hello.... I like your videos. I can't get the bypass key code to work on my login page. What could I be doing wrong?
Hello, thank you for your video. I have a question. If I login as a user with security level 3 and click Yes to turn on the Bypass key, do I have to turn it off again before closing the database?
I followed what you did on the video, but when I click Yes and close the database, I can press the Shift key to bypass and when I close the database again, I can still do it. So I would have tu turn it off again, otherwise it would allow any user to press Shift and bypass if I don't turn it off. Do I have to sign in again and turn it off by clicking No?
+Andrés Auvert You have to turn the bypass key back off to prevent someone from holding the shift key down and gain entry.
Sir Thank you very much for your great video. great work!!!!!!!!!!!
Siva Prasad Thank you for the kind praise.
Hi. Its nice code i got it working. For me need it to add bit extra on password check ("Or IsNull") other wize it was loking with empty Password Field. Not sure if it wasnt the issue for you.
Thanks for shearing it ;)
Hello Steve, seems that the ribbon xml code to lock the Privacy Options does not work for 2016. Any idea on how to get this working again? Thanks.
Hi Steve, I've tried this with Access 2016(365) and it doesn't appear to work. The microsoft site it references to appears to have been removed. Do you have another video or information on how to do this with the current version of Access?
Hi Steve...I love your tutorials. I'm having a problem making this work. I create the USysRibbons table as instructed, close out and re-open the database, but in the current database options where I should select the ribbon name, there is nothing there to select. I have downloaded the work files but I cannot get into the FE database because the path to the BE database is steves_pc, and I cannot get into the front end using the shift bypass key because it was disabled in that tutorial. I can't even get to the point of evaluating the XML code I used in my database because I can't even get the ribbon to show up to select it in options.
+Don D change the path to the back end using the linked table manager and point it to where you are keeping the file.
Hi Steve. Once the front end is secure, how do the users run the reports I made for them? The navigation bar is gone, so they can't get to them.
thank you man, you are the best