Re: Problem passing argument ShellExecute

From: TJ (X_CentralWare_at_yahoo.com)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 15:39:33 -0400

Dan,
    If you have Office installed, MDE/MDW file extensions are already
associated with msAccess so you're actually doing too much work as well as
assuming that if the application was on someone else's computer, they too
are putting MSOffice in C:\Program Files\...

    First, don't bother calling MSAccess.exe - if installed properly its
association will do that work for you.
    Secondly, if long file names are becoming a problem, you're always
welcome to convert 'em to short file names.

    ShellExecute hWnd, "open", mdeFileName$, cmdLineParam$,vbNullString,1
    Leave the DIRECTORY path empty - MSOffice/Access will tend to that
itself.

Take care!

TJ

"dan" <dan@discussions.microsoft.com> wrote in message
news:C25B31D6-F02D-4F9A-A86D-82C3D418B421@microsoft.com...
> If somebody has a clue.
>
> i have 2 access executable files. 1.mde 2.mde I have 2 workgroup
> information tables. 1.mdw 2.mdw.
>
> one of my short cut on my desktop looks like this:
>
> "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Program
> Files\abc\abc application.mde" /wrkgrp "C:\ABC\ABC Data\Data\abc
> workgroupinfofile.mdw"
>
> Now can I use a ShellExecute and pass this whole parameter? I need to
> launch this application as a result of a value or button pressed in a vb6
> application.
>
> Thanks
>
>
>
>