IE Automation Error

[bucko_oz]

Hi


Win7 Pro, Access 2007
Problem:
Within access when i want to open a file folder i have always used SHDocVw (ieframe.dll).

Dim objIE As New InternetExplorer
objIE.Navigate (strFullPath)

And this method has worked fine for years. But now on one of my computers (A) it still works and on Computer B it appears to translate the string and replace back slashes with forward slashes.

Ie when i pass - strFullPath = “S:\Directory Path”
i get an error back – Couldnt find ‘file///S:/Directory%20Path’, followed by an Access ‘Automation Error’

Background:
I have an Access DB which has been running for about 5 years now. I was having some compatibility issues so i upgraded my computers to Win 7 Pro. I already had Office07 running.

My DB resides on Computer B and i generally use my laptop (Computer A). All computers have the same setup as far as i can see. This error was not happening when computer B was running Vista.

The db was converted up to an .accdb, then last back to an .mdb last week, but it was not fixed the issue.

Any clues?????????????

[ajetrumpet]

have you considered trying late binding instead of using the library? I have no idea if that would make a difference, but it's worth a shot.

dim ie as object

set ie = createobject("internetexplorer.application")

ie.navigate

Either that, or maybe you could just use the file system object as a substitute? Are you simply trying to open a folder? Or do you want to view a file in the IE program?