John Colby
jcolby at colbyconsulting.com
Fri May 9 13:02:55 CDT 2003
yes, change the path to access to access10 "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\Access\Assist\DCPP_data.mdb" /compact John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Barbara Ryan Sent: Friday, May 09, 2003 1:56 PM To: Access List Subject: [AccessD] How to compact using Access 2002 I currently compact an Access 97 database using the following line of code in Macro Scheduler (scheduling software): "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Access\Assist\DCPP_data.mdb" /compact 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?? Thanks, Barb Ryan -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030509/2f2c4b05/attachment-0001.html>