5 Ways to PROTECT Ms Access Database
Vložit
- čas přidán 27. 07. 2024
- This video will show you on how to protect or lock your ms access database.
How to Compile Database: • How to COMPILE Microso...
How to Convert ACCDB to ACCDE: • How to create AUTOEXEC...
TIMESTAMP:
00:10 Hiding Database Objects
01:41 Hiding Menus
03:55 Hiding Toolbars/ribbon
06:25 Disable Bypass Key
08:45 Compile your Ms Access Database
Downloadable Templates:
• Free Download Template
KEYWORDS:
How to protect ms access, Ms Access security, How to hide back stage background in Ms access., Microsoft access 365 tutoring,
ms access vba, database, access tutorial for beginners, How to hide menu in ms access,
how to secure ms access database,
ms access hide navigation pane,
ms access 2016 hide database window on startup,
How do I make my Access database secure?
What is the Security of MS Access?
How do I lock an Access database to edit?
How can I protect my Access application?
Securing Your MS Access Database Front-End, MS Access Security - Microsoft Access
#microsoftaccess
#microsoftaccesstutorial
#mstutorial
Hi , Its Very Elegant and smart solution , works great
Thanks for watching.
thumbs up to the great teacher. thanks a lot for the valuable tutorial
Thanks for watching.
bravo you are the best
Thanks
You are welcome. By the way thanks for watching.
Good day sir Ed! I followed your tutorial and it helped me alot and also its user friendly. By the way, I want to open the access options via decelopers settings just like yours but i dont know how. Is there a code needed for it?
Docmd.RunCommand acCmdOptions
Thanks for watching.
Hi Ed , Thank you for your helpful videos. I have a question regarding the login file mentioned in one of your videos. After entering the username and password, the ribbon is hidden as expected. However, the 'File' tab in the ribbon remains accessible, allowing users to open the options menu. Could you please advise on how to hide the 'File' tab both before and after the login file is opened?
First of all, i would like to thank you for watching my video.
Please check this short video to address your concern.
czcams.com/users/shorts_p1Ddn6DsjU?feature=share
@@EdcelleJohnGulfan Dear ED,
Thank you for your Quick response; it is greatly appreciated.
I am able to hide the toolbar ribbon successfully. However, upon login, Access displays the custom ribbon created by me, and the File tab appears, This allows users to open the Options menu from the File tab.
I would like to prevent users from accessing or opening the Privacy Options.
Best regards,
i have been watching your video on how to protect my access but i keep on getting on about my currentDb on the disabling and enabling the shift key. please can you help me fix that error. besides i don't know how to open the access option when i click on the open command option
I'll create a separate video about my master control. Soon i will upload.
By the Way, thanks a lot for watching.
hi. one question. I have a database that is used by several users in the network at the same time. I have a problem during updating the database and I have to ask all users to close the file. Is there a way to solve this problem so that users don't have to close the database anymore when i want change codes or forms or other things?
open the design view of your form and go to form property, DATA, below is Record Locks. Check if it is NO LOCKS.
Good Day Bro. Ed! How did you hide and unhide your MS Access Options Dialog Box the same as you have shown in this video?
Check this time 03:55
@@EdcelleJohnGulfan Bro. Ed Paano mo nagawa yung Open Command Option Button mo nag open sa DB Option?
On click event:
Docmd.RunCommand acCmdOptions
@@EdcelleJohnGulfan Thank you very much Bro. ED. I truly appreciate all your help. May God bless you and your family. I hope that I can personally thank you someday. Mag Bisaya sana ako pero jama-jama Bisaya ko Bro.
Salamat din sa pnonood Sir.
Good evening sir, Your videos are very informative. In your video, you created a developer master control, can you help with a video on how to create a developer master control form.
Yes. I will create a video for that.
@@EdcelleJohnGulfan hi sir, hope you are well, can you let me know the video of the form of developer master control pls because I need it in necessary
@@EdcelleJohnGulfan Hello Dear Bro. we'll be waiting. Thanks
Hi Sir Edcelle, is it possible to show the code behind your button to open the "File-Option" to open the "Access Option" Dialog.. Thank you so much..
Watch this...
czcams.com/users/shortsR492MuN4Bt0?si=fC-iUDb6VKGWUOOO
Hi i run your code but receive the message runtime error 3367 "cannot append. An object with that name already exists in the collection". I clicked debug and it hilite to the last line of code "CurrentDb.Properties.Append CurrentDb.CreateProperty("allowbypasskey", 1, false). How to fix this? Thanks a lot
Good morning sir, Your videos tutorial are very good and understandable. In your video, you created a developer master control, can you help with a full tutorial on how to create a developer master control form
As of now, try this short video. czcams.com/users/shortsR492MuN4Bt0?feature=share
Its most useful can you share this template
Hi Edcelle, I'm Mark and I am wondering if you have a video on how you made your Developers login form? thanks.
Hi Mark, thanks for watching my videos.
You can watch some parts of my Developer Control in my CZcams Shorts videos.
@@EdcelleJohnGulfan I also watched the login part 1 and another video which gave me an idea of redoing my login on my database. Now my Director Loves it. Thanks.
Sir, Customer want to see report from another office , how can i do ? i don't have idea, Could you help me Sir?
save the database in a shared local connection .
Please, can you teach me how to open the login form when I open the system, but when I enter my name and password, the form opens for me, but the system does not open, so please, can you teach me how to configure my login form automatically to open the system. Please do not open the form for me, I am waiting for your answer
Try this link. It's all about login form. czcams.com/play/PLxBRM3hoV3nPnbZUiW92Kgw-gPCeFlp48.html
1st Buddy, Hey I wanted to ask you something
Yup?
I have a database that I splitted and put it in shared drive. Is there a way to protect the code? thanks a lot
Convert it to ACCDE format.
i did convert to 2 files = accde as FE & BE. However, users can only enter, modify data in the FE only if the read, write, modify access granted. And if this is granted, they can also view and modify codes. Thanks for your quick reply. @@EdcelleJohnGulfan
Once converted to accde format, vba codes are no longer visible.
I have a password for my MS Access database, however, for it's size almost reach 2 GB, I have to split it.
Unfortunately, seems that splitting the database also make an easy way for some else to Access my database.
Is there a way to protect both files.
Splitting the database is not a solution for 2gb limit.
You can reduce the size by clicking the COMPACT & REPAIR.
And the best way is to export your tables in SQL. Either MSSQL or MySQL SERVER.
For reference, try this. czcams.com/video/6T1TvSoD_UE/video.html
how to prevent MS Access Database file from copying? deleting and etc?
I have the same question too. I hope sbd could help us
Hello Sir Edcelle Baka Pwede rin ba gumawa kayo ng water refilling System
Yes po. Nice idea. Parang POS lang din yan. Salamat
Paano ung pg open kusang log in ang lalabas
Ito po ang link. czcams.com/video/3DZVrPolX5w/video.html
how can i make open command option please
Type in your command button. OnClick()
DoCmd.RunCommand acCmdOptions
Thanks for the question.
@@EdcelleJohnGulfan Thank U very much
How to create form Developer Master control?
Nice question.
I will create a video for that Pak.
Thanks for watching.
@@EdcelleJohnGulfan
Same here waiting for it
Still waiting
How to create developer login like this
Hiding Ms Access Option: czcams.com/users/shortsR492MuN4Bt0?feature=share
@@EdcelleJohnGulfan thankyou
You're welcome
hellow Sir, how are you? , i want Open Command Option code
Docmd.RunCommand acCmdOptions
Thanks for watching Mamun
@@EdcelleJohnGulfan Thank you sir, i m following your all video
Sir how can i share my access database?
To me?😄
@@EdcelleJohnGulfan example is the person who I'll share my access doesn't have a functional access account what should i do
You are referring about User's Authority Rights
Check this czcams.com/video/8OKX3fY4-g4/video.html
how to protect ms access from HxD
Can I get in touch with you through email
Hi.
Email me at eduardogulfan@gmail.com
Hello, at my work place we have a project for students grades, it is not working anymore, is there any way to fix it? Do you have an email or instagram so can contact you through it please
Thank you so much
contact me at eduardogulfan@gmail.com or in whatsapp +63 933 655 6846.
Thanks