No video

Simple Security for Microsoft Access Databases. Hide Tables. Disable Ribbon. Make ACCDE File.

  Рет қаралды 85,053

Computer Learning Zone

Computer Learning Zone

Күн бұрын

Пікірлер: 85
@xm_tech
@xm_tech 2 жыл бұрын
The ACCDE disables the VBA, took a while to figure things out. Had to debug-compile first in the accdb then save as accde. things are working. thanks for the tutorial.
@599CD
@599CD 2 жыл бұрын
That'll do it
@waltzb7548
@waltzb7548 Жыл бұрын
Just found your channel. I'm a retired ship's captain and years ago using Access 2003 designed a ship's management program. It had a lot of sensitive information since I also designed a payroll program into the database, so it had SS numbers, bank accounts, addresses etc. In Tools I was able to set up permissions for my officers and the database was on ship's server, I was the owner, it lived on the LAN so I could access the mdb from any of the work stations in addition to my office. I just purchased MS Office 2021 and I see the security tools are gone? The log in username and pw and permissions pretty much made it bullet proof, from even my officers in case they felt they wanted to diddle with design or even worse..my functions and code. MS can never seem to leave anything alone, but is the type of security I put into my old database gone? I've subscribed just now to your channel, haven't had a chance to browse through your videos, hoping to find some answers. As I mentioned I'm retired, but that doesn't mean the OCD is retired. You had to demonstrate at least one disorder before you got your own command. Cheers!
@tdp2190
@tdp2190 2 жыл бұрын
Listen Mr Rost YOU ARE FREAKING AWESOME
@599CD
@599CD 2 жыл бұрын
Thanks!!!
@melalama8693
@melalama8693 3 жыл бұрын
Thank you for the great videos. I got answers to everything I need in one or the other video of yours. Highly appreciate your efforts on making them.
@599CD
@599CD 3 жыл бұрын
Glad to help!
@alijan1363
@alijan1363 3 жыл бұрын
but the problem is privacy option. from there users can access data in the users table.
@khalidtanweer7429
@khalidtanweer7429 3 жыл бұрын
Nice one will be in touch with and get my questions answered by you, thanks
@599CD
@599CD 3 жыл бұрын
Feel free to submit your questions at 599cd.com/TH. Members get priority.
@ivansanjuan6316
@ivansanjuan6316 3 жыл бұрын
Thank you for the tutorial. For some reason, from browsing tutorials, I thought I would have needed to do VBA to facilitate these simple security tasks.
@599CD
@599CD 3 жыл бұрын
Simple security like this is possible. There's a LOT more you can do, though, once you do apply a little VBA. 599cd.com/Security
@knamc1
@knamc1 8 ай бұрын
can you add the word templates to access for the mail merge and generate everything out of access?
@599CD
@599CD 8 ай бұрын
I prefer generating everything out of Access. Can you use Access to fill in Word documents? Yeah, sure, but it requires a lot of automation programming.
@justusgwadenya7382
@justusgwadenya7382 3 жыл бұрын
Good and informative tutorials
@599CD
@599CD 3 жыл бұрын
Thanks a lot
@nafeesrehman33
@nafeesrehman33 4 ай бұрын
Great effort Appreciate your efforts
@jwcolby54
@jwcolby54 3 жыл бұрын
Usys prefix when naming any object such as table form quiri Etc. The result is similar to the hidden property.
@599CD
@599CD 3 жыл бұрын
Yep. I try to avoid that though. Those are usually reserved for system objects - but like you said, it WILL work.
@DominiqueKoch-qd2bz
@DominiqueKoch-qd2bz 8 ай бұрын
I've really been enjoying your videos! Thank you so much! I just have a question after watching this video. If there are two databases, the original one only for the "boss" and the ACCDE version for the employees to use, wouldn't the data on the original version become outdated? Wouldn't the boss have to update the data in the tables in the original copy every time he had to make a programming change? Or, how do you handle that? Thank you so much.
@599CD
@599CD 8 ай бұрын
Your database is going to be split in this particular case you're going to have a back end which has your tables on it that'll be up on your server then you're going to have the front end for all the people to use. Now you can have two different versions of your front end if you want one for your boss and one for your workers if the boss needs additional functionality. As far as updating everyone's front end copies go well that can be tricky which is why I built 599cd.com/Updater
@dev6296
@dev6296 Жыл бұрын
Fantastic content very thanks 🙏
@swandipbanerjee2115
@swandipbanerjee2115 2 жыл бұрын
Excellent presentation!!
@599CD
@599CD 2 жыл бұрын
Thank you kindly!
@moodkn
@moodkn 2 жыл бұрын
Thanks! Helpful & Nice Tips
@599CD
@599CD 2 жыл бұрын
Glad it was helpful!
@mukeshphull9352
@mukeshphull9352 2 жыл бұрын
I learned lots of things about the Microsoft access database from your channel. Very valuable educational channel.One question How can create password-protected command button in the access. I will really appreciate if you can share this. Thanks
@599CD
@599CD 2 жыл бұрын
That's covered in the Extended Cut for members.
@gehanameresekere1345
@gehanameresekere1345 3 ай бұрын
Great video
@AH_World_bh
@AH_World_bh 3 жыл бұрын
Thanks n salute from Pakistan
@599CD
@599CD 3 жыл бұрын
Salute!
@tomservo75
@tomservo75 3 ай бұрын
I've used the accde before and I know that this can be used on a computer that does not have Microsoft Access. There are differences, aren't there, between what you can do with an ACCDE on a computer that has Access installed and one that doesn't? Is removing Access from employee computers an option?
@599CD
@599CD 3 ай бұрын
You need to have at LEAST the Access Runtime on their PCs to use an ACCDE file. Aside from that, yeah there are some differences - you lose some of the menu options, and obviously they can't do any design work (but that's a bonus!)
@alijan1363
@alijan1363 3 жыл бұрын
Hello. thanks for the tutorial. but can you help me hiding privacy option in access db file. I did exactly what you did, but still I see privacy option and users can see data in the users table.
@599CD
@599CD 3 жыл бұрын
That is a limitation with Access. You can put a password on the database to prevent people from seeing the table, but unless you encrypt the data, anyone who has access to the tables can see ALL of the data in the tables. See 599cd.com/Encryption. The only good solution to hide data from various users is to use SQL Server.
@user-ll1wb7wd8h
@user-ll1wb7wd8h 2 жыл бұрын
Great videos, Richard
@599CD
@599CD 2 жыл бұрын
Thank you
@poornimataget
@poornimataget 3 жыл бұрын
Awesome tutorials!
@599CD
@599CD 3 жыл бұрын
Thanks!
@waltdunlap6241
@waltdunlap6241 2 жыл бұрын
Great tutorial; however, when I try to encrypt the database the only option, after entering the password, is PRINT. No SAVE AS option.
@599CD
@599CD 2 жыл бұрын
Never seen that before
@restrepojorgea
@restrepojorgea Жыл бұрын
Is there anyway to prevent someone from copying the files with all the information from the shared folder ? In other words, stealing the files maybe for use somewhere else ?
@599CD
@599CD Жыл бұрын
Yeah... use SQL Server for your back-end.
@eleriloki6275
@eleriloki6275 Жыл бұрын
I'm not sure what version of access you are using in your tutorials but you may need to update them to the latest version. I know this tutorial has some wrong information in it. For example, your shift double click to bypass the changes in database options does not work. Also if I make those changes and try to save it as a de file the save option isn't available. Maybe I'm doing something wrong although I am following your tutorial to the letter. Am I missing something?
@599CD
@599CD Жыл бұрын
599cd.com/QQ
@rumanaparveen9755
@rumanaparveen9755 2 жыл бұрын
Dear sir, Is it possible to run my database others computer, If ms office not installed on others computer. can you make a vedio about it
@599CD
@599CD 2 жыл бұрын
599cd.com/Runtime
@microsecure2612
@microsecure2612 2 жыл бұрын
if u can help me with this pls access database all fields shows as ( #Deleted ) knowing that this form was perfectly working and this error happened suddenly
@599CD
@599CD 2 жыл бұрын
599cd.com/2299/access-bug-alert-deleted
@jstan3076
@jstan3076 2 жыл бұрын
Thanks for the tutorial, I try the accde but VBA toggle button does not work. I check if there is any blank VBA but none at all and mistake in Macro. Can you help please
@599CD
@599CD 2 жыл бұрын
I don't understand.
@jstan3076
@jstan3076 2 жыл бұрын
I mean after converting accdb to accde, VBA toggle button stop working. Many Thanks
@oz9985
@oz9985 2 жыл бұрын
i made an accde file but now my login is not working ... why ?
@599CD
@599CD 2 жыл бұрын
No idea.
@Bills_Bicycle_Rides
@Bills_Bicycle_Rides 2 жыл бұрын
Are seminars or status options free too?
@599CD
@599CD 2 жыл бұрын
Seminars are not. What do you mean by status options?
@dmitriyzaslavskiy7223
@dmitriyzaslavskiy7223 2 жыл бұрын
Richard, Is there a way to hide stored login info when connecting Access to SQL Server? I know it's not easy to find for an average user, but the info is still relatively easy to find in hidden objects, even if exported as ACCDE.
@599CD
@599CD 2 жыл бұрын
Yes, you can bury it in your VBA code. I cover that in: 599cd.com/AccessSQL
@MrAimalsultani
@MrAimalsultani 3 жыл бұрын
Well-Done
@599CD
@599CD 3 жыл бұрын
Thanks
@bck4589
@bck4589 2 жыл бұрын
❤️ from India
@599CD
@599CD 2 жыл бұрын
Thanks, from Florida
@smallwoodrh
@smallwoodrh 3 жыл бұрын
Are the steps for storing and accessing database files on a SharePoint location the same as they would be for a local network?
@599CD
@599CD 3 жыл бұрын
Nope. Quite different. 599cd.com/sharepoint
@smallwoodrh
@smallwoodrh 3 жыл бұрын
@@599CD Nice!
@stuxnet2759
@stuxnet2759 3 жыл бұрын
Is it possible to make your own bypass key, Sir? thank u
@599CD
@599CD 3 жыл бұрын
Not that I know of.
@SAJONY-gk7fd
@SAJONY-gk7fd 3 жыл бұрын
Dear Sir would you tell me please how to keep secure my database table, quary, form and report from import option. That's mean how to stop import of my database object. Otherwise anyone can create blank database & import my all database object from file my database or my file path location. Please help me.
@599CD
@599CD 3 жыл бұрын
Creating an ACCDE file as I show in this video should prevent them from stealing your forms, reports, and VBA. I teach how to lock down your database fully in my Security Seminar. 599cd.com/Security
@scomradegh
@scomradegh Жыл бұрын
@@599CD Can he also put a password on the DB? in that case the password would have to be provided before importing can be successful
@lauhaoying626
@lauhaoying626 2 жыл бұрын
The fees for membership is charged in USD?
@599CD
@599CD 2 жыл бұрын
If you join on my site, yes. If you join on KZfaq, I believe it's your local currency, but I'm not sure.
@lauhaoying626
@lauhaoying626 2 жыл бұрын
@@599CD yes youtube is local currency
@Bills_Bicycle_Rides
@Bills_Bicycle_Rides 2 жыл бұрын
How can you say they are always free?
@599CD
@599CD 2 жыл бұрын
Say what's always free? The TechHelp videos are free. Extended cuts are for members.
@rshaddock
@rshaddock Жыл бұрын
Microsoft took away some good features from the .MDB days, such as the User Level Security feature, and ability to use the Environ("UserName") for LastModifiedByUser.
@599CD
@599CD Жыл бұрын
Yeah, I do miss user-level security from Access 2000-2003. Microsoft wants you to use SQL Server for anything "secure" now.
@AbhishekKumar-cq1wy
@AbhishekKumar-cq1wy 3 жыл бұрын
Sir I want create ms access web application how it possible????
@599CD
@599CD 3 жыл бұрын
599cd.com/AConWEB
@AbhishekKumar-cq1wy
@AbhishekKumar-cq1wy 3 жыл бұрын
@@599CD sir please make few videos on it.
@ibrahimhassona9708
@ibrahimhassona9708 3 жыл бұрын
One question, after making the Accde file, is it linked to original accdb file, meaning, if I add new form based on new table will the the new accde will be linked to the update ?
@599CD
@599CD 3 жыл бұрын
Nope
@Jojosmith342
@Jojosmith342 Жыл бұрын
Thumbs up before the class starts for the best teacher Richard. Should this be the step included in kzfaq.info/get/bejne/pdKaZcSAktnJaHk.html? thanks a lot for another great tutorials Richard
How to Add Simple User-Level Security to Microsoft Access Databases
26:44
Computer Learning Zone
Рет қаралды 36 М.
Gli occhiali da sole non mi hanno coperto! 😎
00:13
Senza Limiti
Рет қаралды 18 МЛН
Kind Waiter's Gesture to Homeless Boy #shorts
00:32
I migliori trucchetti di Fabiosa
Рет қаралды 13 МЛН
7 HIDDEN Apps in Microsoft 365 that will EXPLODE Productivity
28:35
Jonathan Edwards
Рет қаралды 209 М.
Creating ACCDE Files in Microsoft Access
16:35
Computer Learning Zone
Рет қаралды 9 М.
When A Gang Leader Confronted Muhammad Ali
11:43
Boxing After Dark
Рет қаралды 7 МЛН
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 520 М.
5 Ways to PROTECT Ms Access Database
9:36
Edcelle John Gulfan
Рет қаралды 12 М.
Gli occhiali da sole non mi hanno coperto! 😎
00:13
Senza Limiti
Рет қаралды 18 МЛН