<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=813190218-09052003><FONT face=Arial color=#0000ff size=2>yes,
change the path to access to access10</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV>
<DIV><FONT face=Arial size=2>"C:\Program Files\Microsoft Office\Office<SPAN
class=813190218-09052003>10</SPAN>\MSACCESS.EXE" "</FONT><A
href="file://pcruri28/C/Access/Assist/DCPP_data.mdb"><FONT face=Arial
size=2>C:\Access\Assist\DCPP_data.mdb</FONT></A><FONT face=Arial size=2>"
/compact</FONT></DIV></DIV>
<P><FONT size=2>John W. Colby<BR>www.colbyconsulting.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Barbara
Ryan<BR><B>Sent:</B> Friday, May 09, 2003 1:56 PM<BR><B>To:</B> Access
List<BR><B>Subject:</B> [AccessD] How to compact using Access
2002<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>I currently compact an Access 97 database using
the following line of code in Macro Scheduler (scheduling
software):</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>"C:\Program Files\Microsoft
Office\Office\MSACCESS.EXE" "<A
href="file://\\pcruri28\C\Access\Assist\DCPP_data.mdb">C:\Access\Assist\DCPP_data.mdb</A>"
/compact</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2>Barb Ryan</FONT></DIV></BLOCKQUOTE></BODY></HTML>