Understanding Macro Blocking and Unblocking
Вставка
- Опубліковано 16 жов 2024
- Understanding how/why files from the Internet, E-mails, ... are having their content/code blocked and demonstrating multiple approaches to unblocking them both manually and via automation.
Note: the blog article includes a download of the demo database as well as VBScript version of the code samples.
We're going to discuss:
• Manually unblocking files
• Using Trusted Locations
• Using the SysInternals Streams Utility
• Using FSO
• Using PowerShell
You may also like to quickly look at:
• • Unblocking Macros - Er...
Blog Articles on the Subject:
• www.devhut.net...
• www.devhut.net...
Other Resources on the Subject:
• • Blocked! How to Deal W...
My Links:
• www.cardaconsu...
• www.devhut.net/
Great video. Awesome information. I've been planning to put together simple video about this. I'll just be mentioning the basics and talking about how to manually unblock or use a Trusted Location. I'm going to point people HERE for the technical details about how to unblock it. Thank you for sharing your knowledge.
My pleasure and let me know when you release your video and I'll add it in the description of this one. You can never have too much good information on a subject!
@@DanielPineault Here it is: ua-cam.com/video/wUMNxesq_ec/v-deo.html - I just covered the basics and then told people to come here for the good goods. :)
I've added it to the description of the video.
Congrats Daniel! I'm also from Richard Rost's videos. For me you are too strong and too forward! Thanks for the videos you post, always very interesting. I signed up too.
Complimenti Daniel! Vengo anche io dai video di Richard Rost. Per me siete troppo forti e troppo avanti! Grazie per i video che pubblicate, sempre molto interessanti. Mi sono iscritto anch'io.
Thank you for your support. It is greatly appreciated.
Thank you for this great information, and I want to thank Richard Rost for sharing the link to it.
You're most welcome.
Richard Rost was right. Great video.
Thank you.
Richard Rost sent me... thankful he did - thanks for the video!
Glad you found it informative.
Great info and well presented. Thanks Daniel.
Thank you. I appreciate the feedback.
Thank you very much Daniel Pineault. Richard Rost send us here. All thumbs up and subscribed as R&R's guide
Thank you!
hey daniel. If i unblock the file on my side and send it to my colleages will it be blocked when they receive it?
From my understanding that depends. If you place it on a corporate server from them to access there should be no issue. It's if you go outside of your network that the block comes into play. So if you use Gmail, ... They it is likely to get blocked again.
So it all depends on how you share the files
@@DanielPineault we use outlook for my company. i want to share it via my work email outlook adresss to my other colleague who is on the same domain on outlook
will it still get blocked?
On the same network there should be no issue, but with Microsoft you never know. Testing is the only real way to know as it can also depend on how IT configured things.
@@DanielPineault, I am the issue with an Access DB on a shared directory on my local area network.
Hi Daniel. Our splitted MS Access DB has error "The action can't be completed because the file is open in another program. Close the file and try again". All users have closed the program but the .lacdb will not go away. I tried to delete the .lacdb and receive this error message. I already changed the trust centre both for BE/FE but the.lacdb is still there. Could you please kindly help me? thanks a lot. Oh, also I tried the other way System Manager to end the process but it requires the Network Admin right. It never happens before.
is this because I added the code to kick users out of program (but I did not tick the option for the time range to kick users yet),
My first thought would be to reboot the computers/server.
You can open the laccdb in a text editor and see what usernames are listed and then go see that they are in fact out of the db and they don't have any hung out hidden processes running.
thank you so much for your quick help Daniel. I rebooted so many times. It won't go away@@DanielPineault
You've rebooted every user PC and the server, then tried to delete the laccdb file?
Could someone be accessing the db remotely?
yes, users might remotely access the DB. However, from the user log report which does not show any users access DB after the regular working hours or weekends. Also, I have procedures to remove users when the DB is idle for 30 minutes and the kick out code to remind them to log out at specific time. I had no issue of deleting this .laccdb in the past. I am not in the office to restart all the DB users. At work, we have some updates . They are trying share point. Could it be the reason? Any possibility? Thanks a lot for your quick help Daniel. Very kind of you @@DanielPineault
the DB is located in Shared Folder. I am the owner (full control). I am not belonging to Network Administrator. I only have the Full Control for the Folder where the BE of DB is located. FE is on users' desktops including me@@DanielPineault
I am having this issue with a Network Shared Access Database. Active Content is being blocked. How can treat this please?
Have you configured a Trusted Location for the Front-End folder (or file)?
@@DanielPineault, I have tried to add the network drive to the trusted location but it says it is not allowed to add a network location even though I have Allow Trusted Location on my networks checked
What about mapping the drive and then adding the mapped drive to the Trusted Locations?
Perhaps you're IT has blocked trusted location creation. You may need to put in a request to then to deal with this.
Most of this security unblock not yet showing
I'm not sure I understand. Could you explain a little more.