ShellExecute error and work anyway...

[hdrolet]

I call the ShellExecute on a MS-Access file, the file open and i receive an error message....

Can you help me ?

ShellExecute("C:\BD\update.mdb")

Error: Windows cannot find "C:\BD\update.mdb".... but the database is open

[Valuater]

Maybe ... try this

Local $file = "C:\BD\update.mdb"

If FileExists($file) Then
    ShellExecute($file)
Else
    MsgBox(0,"Error", $file & " was not found", 5)
EndIf

8)

[hdrolet]

Same probleme

[GEOSoft]

Same probleme

That's apparently an Access error. Can you just open the database in Access with no problems? Was the database created with the same or an older version of Access than you are using? I use ShellExecute with mdb files all the time and there is no problem except where I have created the database using Access 2003 and the user tries to open it with Access 97.

I do beleive that a search of the MS knowledge base will turn up a solution.

[hdrolet]

Can you just open the database in Access with no problems? Yes

Was the database created with the same or an older version of Access than you are using? NO

I go searching in MS knowledge base. If you have another answer or somebody have the same problems, please post it

Thanks

[Noob]

I experience the same problem.

ShellExecute("http://www..............")

ShellExecute() does it's job of opening my webpage, but occasionally I also receive "File cannot be found....." error (while the page opens just fine). I would just need to know how to set @error properly so I never receive the error message :-)

[MHz]

I experience the same problem.

ShellExecute("http://www..............")oÝ÷ Ù(^Q1yË­yÚ²+wöÈènè¥éâ ²ÁæéjºÚq«"¢v¥"Ê+yÇ¢½ê®¢Ñbçz-mçèºwjº^®º+Â¥zØ^¥¨¢§²;¬µø§x(ºWcºËgyçm¢IèÂ0¶µê뢺k¢«+("w¯zºÞqè¯zØ^zºè®g¬±¨þ«¨µå,{*.­³©·öâ¢{-¢ë²)^׫®ÚºÚ"µÍÜ
    ÌÎNÔ[ÜÑ][  ÌÎNË
BÚ[^XÝ]J  ][ÝÚËÝÝÝË][ÝÊBYÜ[NÈ[]HÛÙHÈÙB[Y

[Noob]

Thanks much. I should have done this long ago, but since this occurs infrequently I never bothered :-) I'm assuming it's okay to implement it in my function in the following way:

Opt('RunErrorsFatal', 0)
ShellExecute("http://www..............")
Opt('RunErrorsFatal', 1)

[MHz]

Yep, that is fine. You are suppressing the error, using ShellExecute(), and then resetting the Opt() back to previous fatal on errors. That is indeed fine.

Edited May 2, 2007 by MHz