Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

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
0
giswest
Asked:
giswest
  • 4
  • 3
2 Solutions
 
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
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now