How to run an MDE?

[kenz]

I'm trying to run an .MDE file from a script. I tried just using the Run command but that doesn't work. I'd rather not Run Access with an argument since Access could possibly be installed in diffferent places. Any ideas? Thanks

[Jos]

I'm trying to run an .MDE file from a script. I tried just using the Run command but that doesn't work. I'd rather not Run Access with an argument since Access could possibly be installed in diffferent places. Any ideas? Thanks

<{POST_SNAPBACK}>

try using Run(@comspec & " /c start file.mde", "", @SW_HIDE)

[kenedy]

Try this:

Run (@ComSpec & " /c file.mde")

Heh, too late

Edited November 2, 2004 by kenedy

[normeus]

this one works with win98:

Run("start c:\windows\desktop\1.jpg","", @SW_HIDE)

can't I get a cup of coffee with out someone posting an anwser?

(this is for a jpg file but you know what to do to change it to a ".mde" file )

[kenz]

I tried that but the problem I'm having is that the MDE file is on a network drive. When it tries to execute I get and error about the cmd.exe trying to run from a UNC path which is not supported.

[kenedy]

I'd rather not Run Access with an argument since Access could possibly be installed in diffferent places.

You don't have to know where Access is to launch it. (try Start>Run>msaccess)

Therefore:

Run (@ComCpec & " /c start msaccess argument")

[kenz]

You don't have to know where Access is to launch it. (try Start>Run>msaccess)

Therefore:

Run (@ComCpec & " /c start msaccess argument")

<{POST_SNAPBACK}>

Thanks guys. Kenedy's suggestion worked.