From different resources I found the following tips about decompile:

1. http://www.fmsinc.com/free/newtips/access/accesstip7.asp
"1. From the Windows, Start, Run command line, type: msaccess.exe /decompile
where msaccess.exe includes the complete path. For example:
C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE /decompile
2. When Access opens, open the database you want to decompile (with trusted
authority for Access 2003 or later)
3. Open up any module. Compile it via Debug, Compile.., then File, Save."

and

2. http://www.databasecreations.com/Largedb.pdf
"Our experience has taught us that if you first decompile and then compact
the program file skipping the compile step, the program file is as small as
it can get (often 10-50%% of the original size)."

I have 2 questions about this:

1. How would you decompile when Access is running via Citrix and you don't
know the complete Access path?

2. In tip 2 the compile step is skipped. Is this correct? In order to make
an mde the compile step is required.

Thanks, Lars

1. How can you not know the complete path to Access? In any case, decompile
isn't something you do as a matter of course. It's often useful during
development, but not once the application is in production. See
http://www.trigeminal.com/usenet/usenet004.asp for more details.

2. The compile step is skipped between the decompile and compact step in
order to minimize the size of the mdb. Once you've reduced the size of the
mdb, you can then compile and convert to an mde.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Lars Brownie" brownie.com> wrote in message
news:g302j7$2unc$1@textnews.wanadoo.nl...

This is a Citrix environment with restrictive permissions for its users. I
can't find the complete path anywhere. And if I knew the path, I don't think
I could refer to it in a shortcut.

Lars

"Douglas J. Steele" NOSPAM_canada.com> schreef in bericht
news:O33qmJhzIHA.1240@TK2MSFTNGP02.phx.gbl...

SysCmd(acSysCmdAccessDir) will return the folder where msaccess.exe resides.
For instance, you could run the following VBScript:

Dim objAccess
Dim strPath

Set objAccess = CreateObject("Access.Application")
strPath = objAccess.SysCmd(9)
WScript.Echo strPath
Set objAccess = Nothing

You seem to have ignored my other comment that you shouldn't need to know
this anyhow.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Lars Brownie" brownie.com> wrote in message
news:g3333i$s54$1@textnews.wanadoo.nl...

Thanks Douglas.

I

Decompile the application on your development workstation, compact it and
convert it into an MDE, then give each user a new copy of their MDE.

There's no reason to be doing any of that in the Citrix environment.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Lars Brownie" brownie.com> wrote in message
news:g338tk$u22$1@textnews.wanadoo.nl...

But there is. Since I'm don't have a specific development workstation, I
develop in the same Citrix environment as the users work in (of course in a
separate FE-development.mdb). There is no local Access or data present. All
users have their own instance of the FE in their private network drive and
the backend is on the shared network drive. When users log in into the
application, an automated update routine copies the frontend to the user's
private network drive when an update is available.

Lars

Lars Brownie wrote:

But why don't you have a copy of Access on your own PC? Your company has to
pay for an Access license for you so they might as well give you a "real"
development environment instead of being hobbled by trying to work over
Citrix.

It's company policy to minimize network traffic. And I have never run into
issues with this.

With the code Douglas provided I did manage to find out the full Access path
today and also managed to decompile. Thanks.

Lars

"Rick Brandt" hotmail.com> schreef in bericht
news:F8j5k.10042$uE5.2716@flpi144.ffdc.sbc.com...

Lars Brownie wrote:

But you are using MORE network traffic to do this via Citrix than if you did
it locally.

Citrix is good for running Access apps when you don't have a good LAN
connection. It is not good for developing them. Unless...are you doing
this remotely or are you are on the same local network as the Citrix server?