Susan Harkins
harkins at iglou.com
Mon Aug 18 18:46:15 CDT 2003
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 > >