John Colby
jcolby at colbyconsulting.com
Mon Aug 18 19:44:21 CDT 2003
Open the dos box, then execute each command one at a time. Since you opened the dos box, it won't close until you tell it to and you should be able to see any errors reported back to the dos box. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins Sent: Monday, August 18, 2003 7:46 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] this should be an easy one -- on Windows shortcuts Thanks Marty, but it just flashes and that's it -- can't tell a thing. I did delete the @Echo Off statement too. Shold the statement I used work as I expected, with Access remaining open? Right now, the compact does take place, but Access shuts down when it's done. Is there a switch for "remain open?" Susan H. > You could put this code below in a notepad file call it try.bat and > execute the batch file from the shortcut. > You can remove the echo command to see what is happening > However this has the annoying habit of leaving the cmd window open or > minimized in the systray > until you exit Access. > > @Echo Off > "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\xml\Access > XML tests\RSS xml.mdb" /compact > "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\xml\Access > XML tests\RSS xml.mdb" > @cls > > Susan Harkins wrote: > > >"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" C:\a\topics.mdb > >/compact > > > >I tried the above as a shortcut's Target property to open a database and > >compact and repair it -- problem is, the database doesn't stay open. I want > >it to stay open. > > > >Susan H. > > > >_______________________________________________ > >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 > > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com