[AccessD] Compacting w/a shortcut (Was: Decompile / compile)

Dan Waters df.waters at comcast.net
Wed Oct 20 10:11:36 CDT 2010


I set up a specific shortcut to compact an mdb.

Set up the target field like this:

"C:\Program Files (x86)\Microsoft Office\OFFICE11\MSACCESS.EXE"
"C:\PSISystemClient\FrontEnd\PSILibrary.mdb" /compact

Notice that the path to the access executable is listed first, and it uses
double quotes at the beginning and end.  Next is the path to your file, also
using double quotes.  Next is the /compact command.

When the shortcut is set up like this, I can click on the shortcut, the
access file open, compacts, and closes without running code.  It's fast!

If your file uses any security, you can enter your username and password,
then the /compact command:  /user dwaters /pwd abcde /compact

HTH!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael Mattys
Sent: Wednesday, October 20, 2010 9:19 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Decompile / compile

I've always compacted after while holding the shift key ...

Michael R Mattys
Business Process Developers
www.mattysconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, October 20, 2010 10:10 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Decompile / compile

I use a shortcut to Access with the /Decompile switch such that when I use
that shortcut Access 
opens with the decompile stuff.  I then open the container I want to
decompile and the decompile 
happens.

I have always then closed Access and opened it again through another
shortcut so that the decompile 
is not being used.

My question is, can I do the decompile, and then just compile without
closing and reopening Access. 
  I assume that I can but I have never been sure on that.

-- 
John W. Colby
www.ColbyConsulting.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list