<br><font size=2 face="sans-serif">Make sure that the Access 2002 exe file is in the location you are specifying. </font>
<br>
<br><font size=2 face="sans-serif">The other thing to double check would be the actual file name you are attempting to compact.</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>"Barbara Ryan" <BarbaraRyan@cox.net></b></font>
<br><font size=1 face="sans-serif">Sent by: accessd-bounces@databaseadvisors.com</font>
<p><font size=1 face="sans-serif">05/09/2003 12:55 PM</font>
<br><font size=1 face="sans-serif">Please respond to accessd</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To: "Access List" <AccessD@databaseadvisors.com></font>
<br><font size=1 face="sans-serif"> cc: </font>
<br><font size=1 face="sans-serif"> Subject: [AccessD] How to compact using Access 2002</font></table>
<br>
<br>
<br><font size=2 face="Arial">I currently compact an Access 97 database using the following line of code in Macro Scheduler (scheduling software):</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 face="Arial">"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "</font><a href=file:////pcruri28/c/access/assist/dcpp_data.mdb/><font size=2 color=blue face="Arial"><u>C:\Access\Assist\DCPP_data.mdb</u></font></a><font size=2 face="Arial">" /compact</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 face="Arial">The code is not working at a site that is using Access 2002 ("Office" was changed to "Office10"). Any ideas on how to fix it??</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 face="Arial">Thanks,</font>
<br><font size=2 face="Arial">Barb Ryan</font><font size=2 face="Courier New">_______________________________________________<br>
AccessD mailing list<br>
AccessD@databaseadvisors.com<br>
http://databaseadvisors.com/mailman/listinfo/accessd<br>
Website: http://www.databaseadvisors.com<br>
</font>
<br>
<br>