Steve Capistrant
scapistrant at symphonyinfo.com
Wed Jun 22 17:03:39 CDT 2005
Has anyone tried building some routine that scans all tables in an Access database for corruption? I'd be interested in implementing this as part of an overall preventative (sort of) maintenance or troubleshooting process. It seems possible to do, because certain routine actions -- like copying a table -- will fail if the table has a corruption. Run a routine that looped through the tables collection, copy each to an external temporary database, trap for errors at each step, and display the name of each corrupted table. Scanning at the record level might be trickier, because you usually can't return the ID of a corrupted record. Thoughts? Steve Capistrant scapistrant at symphonyinfo.com Symphony Information Services 7308 Aspen Lane North, Suite 132 Brooklyn Park, MN 55428 763-391-7400 www.symphonyinfo.com