5 Ways to PROTECT Ms Access Database

[@HusnaSadat-fo4zt]

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]

Try this link. It's all about login form. kzbin.info/aero/PLxBRM3hoV3nPnbZUiW92Kgw-gPCeFlp48

[@nicemedia1]

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.

[@GreateAcc]

Hi , Its Very Elegant and smart solution , works great

[@EdcelleJohnGulfan]

Thanks for watching.

[@samiamadeus]

how to protect ms access from HxD

[@nhyiraback5899]

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]

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

[@markdesens3046]

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

[@EdcelleJohnGulfan]

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

[@markdesens3046]

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

[@raedajailat9958]

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]

First of all, i would like to thank you for watching my video. Please check this short video to address your concern. kzbin.info_p1Ddn6DsjU?feature=share

[@raedajailat9958]

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

[@WengoBalor]

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]

Docmd.RunCommand acCmdOptions Thanks for watching.

[@mamunmuscatbd]

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

[@EdcelleJohnGulfan]

save the database in a shared local connection .

[@TechWithSally4D]

1st Buddy, Hey I wanted to ask you something

[@EdcelleJohnGulfan]

Yup?

[@Jojosmith342]

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

[@EdcelleJohnGulfan]

Thanks for watching.

[@josmaitconsult8913]

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]

Yes. I will create a video for that.

[@minicourse7359]

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

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

[@Jojosmith342]

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]

Convert it to ACCDE format.

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

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

[@Water7Aquatic]

How to create developer login like this

[@EdcelleJohnGulfan]

Hiding Ms Access Option: kzbin.infoR492MuN4Bt0?feature=share

[@Water7Aquatic]

@@EdcelleJohnGulfan thankyou

[@EdcelleJohnGulfan]

You're welcome

[@strive4peaceksa]

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]

Watch this... kzbin.infoR492MuN4Bt0?si=fC-iUDb6VKGWUOOO

[@n2d2cool]

Its most useful can you share this template

[@migomotovlog]

Paano ung pg open kusang log in ang lalabas

[@EdcelleJohnGulfan]

Ito po ang link. kzbin.info/www/bejne/aXW9h6WGpNGLa9k

[@alializadeh8195]

Thanks

[@EdcelleJohnGulfan]

You are welcome. By the way thanks for watching.

[@nhyiraback5899]

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]

As of now, try this short video. kzbin.infoR492MuN4Bt0?feature=share

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

[@El-Ge]

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]

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. kzbin.info/www/bejne/bIWUhamJpKmSi6c

[@elizalapidez5432]

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

[@kensimba7868]

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

[@zessreltrazona5316]

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

[@EdcelleJohnGulfan]

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

[@airdrop2670]

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]

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

[@mamunmuscatbd]

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

[@EdcelleJohnGulfan]

Docmd.RunCommand acCmdOptions

[@EdcelleJohnGulfan]

Thanks for watching Mamun

[@mamunmuscatbd]

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

[@samiamadeus]

how can i make open command option please

[@EdcelleJohnGulfan]

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

[@samiamadeus]

@@EdcelleJohnGulfan Thank U very much

[@jamesscarsce8452]

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]

Check this time 03:55

[@jamesscarsce8452]

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

[@EdcelleJohnGulfan]

On click event: Docmd.RunCommand acCmdOptions

[@jamesscarsce8452]

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

Salamat din sa pnonood Sir.

[@BestFriendsForeverTrue]

How to create form Developer Master control?

[@EdcelleJohnGulfan]

Nice question. I will create a video for that Pak. Thanks for watching.

[@Excelandaccessusefultips]

@@EdcelleJohnGulfan Same here waiting for it

[@Water7Aquatic]

Still waiting

[@polarisreeva6274]

Sir how can i share my access database?

[@EdcelleJohnGulfan]

To me?😄

[@polarisreeva6274]

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

[@EdcelleJohnGulfan]

You are referring about User's Authority Rights Check this kzbin.info/www/bejne/boCuiWacjplgnZY

[@skvinchaxxxskvincha288]

bravo you are the best

[@Hajora21]

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]

contact me at [e-mail] or in whatsapp [phone]. Thanks

[@Excelandaccessusefultips]

Can I get in touch with you through email

[@EdcelleJohnGulfan]

Hi. Email me at [e-mail]