5 Ways to PROTECT Ms Access Database

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 ธ.ค. 2024

ความคิดเห็น •

  • @GreateAcc
    @GreateAcc ปีที่แล้ว +2

    Hi , Its Very Elegant and smart solution , works great

  • @Jojosmith342
    @Jojosmith342 ปีที่แล้ว +1

    thumbs up to the great teacher. thanks a lot for the valuable tutorial

  • @raedajailat9958
    @raedajailat9958 5 หลายเดือนก่อน +1

    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?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  5 หลายเดือนก่อน

      First of all, i would like to thank you for watching my video.
      Please check this short video to address your concern.
      th-cam.com/users/shorts_p1Ddn6DsjU?feature=share

    • @raedajailat9958
      @raedajailat9958 5 หลายเดือนก่อน +1

      @@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,

  • @nicemedia1
    @nicemedia1 4 หลายเดือนก่อน

    Hello Sir and thanks for your nice videos.
    I have a big problem in first time open my database in other computer. Because bypass security automatically disable duo to trust location, so as result option meno and every things are visible..!!
    So I can't send my db to any one online, and I must go there and set the trust location manually and then everything works well.
    I want to the program works in any location without warning.
    Thanks.

  • @strive4peaceksa
    @strive4peaceksa 8 หลายเดือนก่อน

    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..

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  8 หลายเดือนก่อน

      Watch this...
      th-cam.com/users/shortsR492MuN4Bt0?si=fC-iUDb6VKGWUOOO

  • @markdesens3046
    @markdesens3046 5 หลายเดือนก่อน

    Hi Edcelle, I'm Mark and I am wondering if you have a video on how you made your Developers login form? thanks.

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  4 หลายเดือนก่อน +1

      Hi Mark, thanks for watching my videos.
      You can watch some parts of my Developer Control in my TH-cam Shorts videos.

    • @markdesens3046
      @markdesens3046 4 หลายเดือนก่อน +1

      @@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.

  • @WengoBalor
    @WengoBalor 2 ปีที่แล้ว +1

    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?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว +1

      Docmd.RunCommand acCmdOptions
      Thanks for watching.

  • @Jojosmith342
    @Jojosmith342 ปีที่แล้ว +1

    I have a database that I splitted and put it in shared drive. Is there a way to protect the code? thanks a lot

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  ปีที่แล้ว +1

      Convert it to ACCDE format.

    • @Jojosmith342
      @Jojosmith342 ปีที่แล้ว

      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

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  ปีที่แล้ว +1

      Once converted to accde format, vba codes are no longer visible.

  • @jamesscarsce8452
    @jamesscarsce8452 2 ปีที่แล้ว

    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?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว +1

      Check this time 03:55

    • @jamesscarsce8452
      @jamesscarsce8452 2 ปีที่แล้ว

      @@EdcelleJohnGulfan Bro. Ed Paano mo nagawa yung Open Command Option Button mo nag open sa DB Option?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว +3

      On click event:
      Docmd.RunCommand acCmdOptions

    • @jamesscarsce8452
      @jamesscarsce8452 2 ปีที่แล้ว

      @@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.

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว +1

      Salamat din sa pnonood Sir.

  • @nhyiraback5899
    @nhyiraback5899 11 หลายเดือนก่อน

    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

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  11 หลายเดือนก่อน

      I'll create a separate video about my master control. Soon i will upload.
      By the Way, thanks a lot for watching.

  • @mamunmuscatbd
    @mamunmuscatbd 2 ปีที่แล้ว +1

    Sir, Customer want to see report from another office , how can i do ? i don't have idea, Could you help me Sir?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว

      save the database in a shared local connection .

  • @airdrop2670
    @airdrop2670 2 ปีที่แล้ว

    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?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว

      open the design view of your form and go to form property, DATA, below is Record Locks. Check if it is NO LOCKS.

  • @El-Ge
    @El-Ge 2 ปีที่แล้ว

    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.

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว

      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. th-cam.com/video/6T1TvSoD_UE/w-d-xo.html

  • @Jojosmith342
    @Jojosmith342 ปีที่แล้ว

    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

  • @josmaitconsult8913
    @josmaitconsult8913 2 ปีที่แล้ว +1

    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.

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว +2

      Yes. I will create a video for that.

    • @minicourse7359
      @minicourse7359 ปีที่แล้ว +1

      @@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

    • @polakurdish
      @polakurdish ปีที่แล้ว

      @@EdcelleJohnGulfan Hello Dear Bro. we'll be waiting. Thanks

  • @HusnaSadat-fo4zt
    @HusnaSadat-fo4zt 6 หลายเดือนก่อน +1

    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

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  6 หลายเดือนก่อน

      Try this link. It's all about login form. th-cam.com/play/PLxBRM3hoV3nPnbZUiW92Kgw-gPCeFlp48.html

  • @samiamadeus
    @samiamadeus 2 ปีที่แล้ว

    how can i make open command option please

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว

      Type in your command button. OnClick()
      DoCmd.RunCommand acCmdOptions
      Thanks for the question.

    • @samiamadeus
      @samiamadeus 2 ปีที่แล้ว

      @@EdcelleJohnGulfan Thank U very much

  • @BestFriendsForeverTrue
    @BestFriendsForeverTrue 2 ปีที่แล้ว

    How to create form Developer Master control?

  • @Water7Aquatic
    @Water7Aquatic 7 หลายเดือนก่อน

    How to create developer login like this

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  7 หลายเดือนก่อน +1

      Hiding Ms Access Option: th-cam.com/users/shortsR492MuN4Bt0?feature=share

    • @Water7Aquatic
      @Water7Aquatic 7 หลายเดือนก่อน +1

      @@EdcelleJohnGulfan thankyou

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  7 หลายเดือนก่อน

      You're welcome

  • @elizalapidez5432
    @elizalapidez5432 ปีที่แล้ว

    how to prevent MS Access Database file from copying? deleting and etc?

    • @kensimba7868
      @kensimba7868 9 หลายเดือนก่อน

      I have the same question too. I hope sbd could help us

  • @migomotovlog
    @migomotovlog ปีที่แล้ว

    Paano ung pg open kusang log in ang lalabas

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  ปีที่แล้ว

      Ito po ang link. th-cam.com/video/3DZVrPolX5w/w-d-xo.html

  • @n2d2cool
    @n2d2cool 11 หลายเดือนก่อน

    Its most useful can you share this template

  • @nhyiraback5899
    @nhyiraback5899 11 หลายเดือนก่อน

    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

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  11 หลายเดือนก่อน

      As of now, try this short video. th-cam.com/users/shortsR492MuN4Bt0?feature=share

  • @zessreltrazona5316
    @zessreltrazona5316 2 ปีที่แล้ว

    Hello Sir Edcelle Baka Pwede rin ba gumawa kayo ng water refilling System

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว

      Yes po. Nice idea. Parang POS lang din yan. Salamat

  • @alializadeh8195
    @alializadeh8195 ปีที่แล้ว +1

    Thanks

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  ปีที่แล้ว

      You are welcome. By the way thanks for watching.

  • @polarisreeva6274
    @polarisreeva6274 2 ปีที่แล้ว

    Sir how can i share my access database?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว +1

      To me?😄

    • @polarisreeva6274
      @polarisreeva6274 2 ปีที่แล้ว +1

      @@EdcelleJohnGulfan example is the person who I'll share my access doesn't have a functional access account what should i do

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว

      You are referring about User's Authority Rights
      Check this th-cam.com/video/8OKX3fY4-g4/w-d-xo.html

  • @mamunmuscatbd
    @mamunmuscatbd 2 ปีที่แล้ว

    hellow Sir, how are you? , i want Open Command Option code

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว

      Docmd.RunCommand acCmdOptions

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว

      Thanks for watching Mamun

    • @mamunmuscatbd
      @mamunmuscatbd 2 ปีที่แล้ว +1

      @@EdcelleJohnGulfan Thank you sir, i m following your all video

  • @TechWithSally4D
    @TechWithSally4D 2 ปีที่แล้ว +1

    1st Buddy, Hey I wanted to ask you something

  • @samiamadeus
    @samiamadeus 11 หลายเดือนก่อน

    how to protect ms access from HxD

  • @Excelandaccessusefultips
    @Excelandaccessusefultips 2 ปีที่แล้ว

    Can I get in touch with you through email

  • @Hajora21
    @Hajora21 2 ปีที่แล้ว

    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

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว +1

      contact me at eduardogulfan@gmail.com or in whatsapp +63 933 655 6846.
      Thanks