Question: SysCmd function translation into VB
Certainly. This is the key for the Access.Application.8
CLSID. I was simply saying that (a) the code for the SysCmd
was not available to anyone outside MS, and (b) even if (a)
were not true, the code would not help. Thats all.
Assuming Access is registered, that key should always be
present. It might be morr robust to look up
Access.Application.8 to get the CLSID instead of hardcoding
it, which will make it easier to convert if and when you
change versions of Access.
--
MichKa
-------------------------------------
don't send questions by e-mail unless
you're paying for it. (TANSTAAFL!) :-)
random junk of dubious value and
replica error and problem fixing at:
http://www.trigeminal.com
Quote:
> found the magical key.
HKEY_CLASSES_ROOT\CLSID\{8CC49940-3146-11CF-97A1-00AA00424A9
F}
Quote:
> This key contains the full name and path of the access
exe. Re-installed
> access
> on a test machine to a totally different dir, and the key
above reflects the
> new
> location.
> cheers,
> Nolan
Quote:
> >It gets its info from code inside of Access.... which has
an
> >easy time getting its own path while its running.
> >In other words, even you had magical access to
msaccess.exe
> >source code, it would not help you here.
> >--
> >MichKa
> >-------------------------------------
> >don't send questions by e-mail unless
> >you're paying for it. (TANSTAAFL!) :-)
> >random junk of dubious value and
> >replica error and problem fixing at:
> >http://www.trigeminal.com
> >> Access has got a powerful SysCmd function which I use
to
> >shell
> >> another copy of Access , like so:
> >> EXE_Path = SysCmd(acSysCmdAccessDir) & "msAccess.Exe "
> >> Works well!!
> >> Anyone know where this command gets its information?
> >> I need to port the commnad to Shell Access from VB.
> >> many thanx
> >> Nolan C
