MS Access-IE Security Issue

I've created a form containing an Active X Control Microsoft Web Browser, which functions as a Windows Folder/File Explorer (See attached image), so that database users can view files (attachements) associated with indiviudual database records.  The form and browser functions great, but any time I attempt to open a file contained in the "attachments" folder I recieve the following IE warning "Running a system command on theis item might be unsafe. Do you wish to continue?"  I've researched this issue to find a work around for bypassing the warning, but didn't come up with much.  One person suggested enabling the "Launching applications and unsafe files option" on the Internet Security options.  I didn't like this solution because it increases risks to my computer.

Any help with this issue is appreciated.
MS-Access-IE-Security-Issue.png
giswestAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

shahravishCommented:
I have come across similar issues, and many have been the local machine and some remote machines. Is thie procedure calling a UNC path?
Either way, try to add the machine name or ip the file is being loaded or called from, to the trusted sites list under IE.
0
giswestAuthor Commented:
shahravish,

I had the web browser directed to a share folder, which is mapped as a network drive (Y:\), on a network server.

    Dim strURL As String
    Dim objIE As Object
       
    strURL = "Y:\Attachments\" & Form_Sale_Management.Sale_Index.Value
    Set objIE = Me.WebBrowser0.Object
    objIE.Navigate strURL

Based on your suggestion, I changed the path to:

strURL = "\\192.168.0.44\AAI_Share\Attachments\" & Form_Sale_Management.Sale_Index.Value

This allows me to still access the attachments folders via MS Access database.  In additon, I added the following location to the Trusted Sites:

http://192.168.0.44/Attachments/

Unfortunately, I still have the same issue.  Please let me know if you have any additional input.

Thank you.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Your Trusted Site location:

http://192.168.0.44/Attachments/

Is different from your strURL value:

strURL = "\\192.168.0.44\AAI_Share\Attachments\" & Form_Sale_Management.Sale_Index.Value

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

shahravishCommented:
I would suggest just add the trust site URL as http://192.168.0.44 rather than defining, unless you have a requirement to specifically define. You could test with the IP address only.
0
giswestAuthor Commented:
shahravish & LSM:  I changed the Trusted Site Location to:

http://192.168.0.44/AAI_Share/Attachments/ 

However, when I add the location it's truncated to http://192.168.0.44/, which is what shahravish suggested.  Unfortunately, I still have the same issue.  The web browser path in Access is still set as:

strURL = "\\192.168.0.44\AAI_Share\Attachments\" & Form_Sale_Management.Sale_Index.Value

Any addtional suggestions?
0
shahravishCommented:
you may also want to add file://192.168.0.44 since youwill be accessing via windows explorer
0
giswestAuthor Commented:
shahravish,

I added file://192.168.0.44 as a trusted location when I added http://192.168.0.44.  Still no luck.
0
giswestAuthor Commented:
shahravish & LSM,

Thank you both for you input on this issue.  Although I wasn't able to resolve this issue, it's not something that will drastically impede our workflow.

Again, thank you for your help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.