59. Securing Your Front End (Programming In Microsoft Access 2013) 🎓
HTML-код
- Опубликовано: 7 май 2014
- A newer version of this series has started for Microsoft Access 2016 here:
• Microsoft Access 2016 ...
----------
Securing Your Front End in "Programming in Microsoft Access 2013". Hosted by Steve Bishop.
In this free beginner video tutorial series Steve will be going over Database Development in Access, creating the User Interface, and coding the backend of the application in Visual Basic for Applications (VBA).
Update: Due to some kookiness in Access, the ribbon XML has been updated in the work file. Please check the work file to see how to get rid of the Privacy Options.
Click here for the full playlist of "Programming in Access 2013"
• Programming in Microso...
Click here for the Work Files of this series:
github.com/Xipooo/Programming...
----------
Become a member today for only $5 a month!
/ @programmingmadeez
When you join, here’s what you’ll get:
* Your name in the credits
* A form to ask me for help on your project
* 10% off in the Teespring store (discount code)
----------
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: / @coffeewithsteve
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: ruclips.net/channel/UCeXAUvo5xxDY_b-lSknPC1A
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.
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!\
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.
Thank you Mr.Steve for your easy to follow tutorial video.
man .. you amazing .. i had good experience in MS Access .. but with your videos now i get more and more .. thanks
Thanks dear, i recommended this channel to my friends.
+Renjith Kuttichira Well thank you very much!
Thank you Mr.Steve for your easy to follow video.
this video is again EXACTLY what I needed. Thank you!!!!!!!!!!!
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.
Thanks Steve, very much appreciated.
Keep the good work coming. 👌
Hi! Steve, thank you for your great work. Is this code worked with MS Access 2007 version? Can we disable F11 key in vba?
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
Great video! I started Access VBA programming by watching your videos. Thanks
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.
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".
Hi Steve,
I want to know how you hide those first few database table options in your video? Plz explain.
Long live Steve, really you're great, best wishes, regards
This is brilliant. Thank you 😊
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.
Hi Steve can I disable shortcut menue for certain users and enable it for others? @Programming , +Programming
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
Hello Sir I have MSAccess built Application. I want to change some functionality in database .Give some idea how can i change it ?
Thanks
Is there a way to set the CustomUI by user from the login screen? I need to enable the paste function for a manager user level.
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.
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.
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 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.
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
Great video thank you. Question, do you need to even do this if you are using Ms Access runtime?
thank you man, you are the best
Wow so many years passed for me :v
Need to ask after I applied thie code (custom UI etc etc) . Then reopen file and going in to "options" , the Ribbon name has blank result and also the dropdown . why ? (sorry for my bad english)
Sir Thank you very much for your great video. great work!!!!!!!!!!!
Siva Prasad Thank you for the kind praise.
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!
Excellent... I really appreciate you...
Thank you so much for your help!
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
Pls help me I have done all that but when i am trying to bypass it with shift key it is not working
IF only i saw this video earlier. Thanks you for been generous like this
Thank you! Very helpful.
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?
Hello. Will the language you give in the data table to hide away privacy settings also worked with access 2016?
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.
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,
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.
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.
I am using Access 365 (2020) and when I create the USysRibbons table I cannot see it in the Navigation pane. If I try to recreate it Access says a table with that name already exists. Also I don't get the ability to choose the "Default" Ribbon as you instruct, possibly because of the first issue. What am I missing, doing incorrectly.
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
Man, you're the BEST!!! Thanks
Hello, its been a while i see, still hoping for feedback. After inserting the login screen, everything works great, but when i try to change the login screen in any way then access stop working and needs to be restarted, but the databse has been currupted and can not been used again, why is this ?
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
Do you have the no ribbon display code in a better readable display? Does this still work in Access 2016?
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
Hi Mr steve, I did Everything in your video and I published it to the users also. But I just found out an issue that on my computer,everything looks fine. But after I copied the application to a user's laptop, since the security issue, that laptop doesn't allow me to login, instead it shows a close button on the right top of the login form which was forbidden in the design mode on my computer already. So when I click it, the login form is closed and I can still right click on Home or File tab to get access to "Customize the Ribbon" which goes directly to Access Options. So in this case, I cannot secure my database from users end. How can I fix it? Thank you
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.
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?
Hey, so I'm trying to do this for my company, but my boss wants the security to be by the user instead of by class. I have an employee table like yours and an access table. Th access table has each individual Id number and each column is a checkbox with the individual tables as the column names. I can't seem to get it to work. Please help.
Hi,Do all of the users use the same client db (on a share on the network) or does the client get distributed to each user's workstation? Wouldn't it be easier to lock down the client that normal user's use and keep an unlocked version for the developer to use to access the same data? I have an inventory database that must be kept simple for the users and shouldn't have a password (for some reason). I haven't split it yet but that is the intention. I will password protect the back end db so no one can access it directly. I will be disabling a couple of buttons based on the user. One thing that is necessary is to limit what the users can alter to make sure there are no shenigans.Am I just making this more complicated than it needs to be?Thanks,Mike
Hi Steve, unfortunately it does not work in Microsoft 365. Does it work in Access 2016? Do you have the updated version?
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.
There is another way users can simply access the tables and what not. In the quick access toolbar if they select 'More commands 'it will directly take them to 'Access Options'. How can i hide the quick access toolbar?
Very neat and nice solution
+wcambris Thank you!
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?
Excellent videos, The Ribbon XML code does not seem to work with Access 2016, Do you have a fix for this?
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 video thank u
You're the best.
Welldone i love your videos
Hi steve, I am trying to create a ledger in MS Access with a running total but cant seem to build from the expression builder the correct sum. The difficulty is that i want to add the previous balance in a row add another debit amount to it and minus a credit to give me a new balance.
Could you or anyone reading this help me out, please.
Thanks
After I tried to login, I get an error message "Runtime error '3031' Not a valid password". I believe it may be the the fact that I use Access 2007 and have Windows 10. How can it be fixed?
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.
What if i want the end user to interact with only the forms i create and not have them see MS Access itself in the background?
I just noticed the link in doesn't work if I try to open it. Also wondering, how come you enter your username incorrectly (sbishop instead of sBishop, as it displays in tblEmployees) but it still works. Is it not case sensitive? I've downloaded the working files but it won't let me login using either username. Is password still you password for the Services Inc_fe.accdb file.
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.
hey is there any relation between employeeid and employeetypes?
👍 Great, please let us know how we can get the Default Ribbon XML text, you mentioned!?🙏
Notification popup -"Can't overwrite table or query" while importing data as form is base on query! Please help me
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 !!!.
Thank you Sir
do you have any video regarding pick and pack goods,
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.
Awesome!
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.
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.
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.
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.
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.
thank you very much
is there a way to disable quick access toolbar in print preview
Dear Sir, I use your code On Microsoft Access 365 it not working it is still seen Option please help with the code for Access 365. i'm waiting your new video
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.
How about getting rid of everything on the screen and only show the forms
if the user has full version of MS Access, they can gain full access to the data (including passwords) via the import option within a new database ... can you do another video on how to stop this .. please
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
U sir are amazing!! U got a sb..
Thank you and welcome aboard!
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.
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.
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?
hiding the options code does not work for access 2019, is there a solution to this?