John Skolits
askolits at nni.com
Thu Dec 6 10:37:03 CST 2007
My customer just told me that the compacted file was inheriting the permission from the folder permissions which was read only. Yet, if you compact from within Access, this does not happen. Odd Thanks anyway. John -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits Sent: Thursday, December 06, 2007 11:21 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Compacting DB with batch file makes MDB read Only I have a customer who is doing nightly compacts. He runs the following in a batch (.bat) file. "C:\Program Files\Microsoft Office\Office11\MsAccess.exe" "\\corp01\shared\GeneralDocuments\Corporate\EDI_DB\EDI.mdb" /Compact Exit Once it finishes compacting, the new DB is now read only in it's file's permissions. Any ideas why? John Skolits -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com