Dan Waters
dwaters at usinternet.com
Tue Aug 23 08:26:10 CDT 2005
It's weird, but not unusual. :-( Glad to hear to hear you got it all back!! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Monday, August 22, 2005 10:53 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Cannot Compact and Repaid (Access 2003) Truly weird. I pulled all the objects into a new MDB, 10 at a time, compacting after each pull. Everything came in and everything compiled, and the file size went from 31 MB to 5 MB. All is bliss, all is bliss. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: August 22, 2005 8:48 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Cannot Compact and Repaid (Access 2003) All the tables are linked, not resident in the FE itself. But I guess that you are correct, I should import group by group and compact after each. Bummer! Arthur -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com