[AccessD] \decompile

[Rocky Smolin]

I'm using Office 2010.  I opened the RIN app and browsed for MSACCESS.EXE.

This in the run box: "C:\Program Files (x86)\Microsoft
Office\Office14\MSACCESS.EXE"opens access.

Adding the path and file name of one of my clients' FEs opens the app:

"C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE"
C:/Clients\AGR\AGR_FE_282.accdb
Adding the decompile switch pears to be doing the job:

"C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE"
C:/Clients\AGR\AGR_FE_282.accdb /decompile

I don't know if any of this will be helpful, but if the decompile statement
is not in the save RUN commands, then I always browse to the location of
MSACCESS>EXE because i'll for sure make at least one mistake keying it
manually.

r



On Tue, Apr 12, 2022 at 6:04 PM John Colby <jwcolby at gmail.com> wrote:

> In the past I always created a batch file to perform a \decompile when I
> opened Access.  I don't have that now so I am creating one.  I found the
> syntax out on FMS as follows:
>
> "C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE
> /decompile"
>
> where the path depends on your instance of Office.  This is in fact my
> correct path.
>
> If I open the command window and paste that in it returns an error message
> "The directory name is invalid".  If I perform a CD C:\Program Files
> (x86)\Microsoft Office\root\Office16 it does in fact change directory into
> that path and from there a  MSACCESS.EXE /decompile opens access.
>
> So what gives?  Majorly confused on this part.
>
> Is it possible to do the same thing with a shortcut to Access?  I created
> the shortcut and placed the /decompile inside of the quotations and Access
> opens, however there is no obvious way to determine whether the /decompile
> is passed in to the access instance.  I vaguely remember that this is the
> method that I used in the past.
>
> I assume that some of you guys do this stuff?
>
> --
> John W. Colby
> Colby Consulting
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>