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