Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 7th, 2005, 05:46 PM
Authorized User
 
Join Date: Oct 2003
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I've also been working with MS Access since v1.1 and have seen this same problem where databases get corrupted and then trying to recover as much as possible manually. As far as an answer to the last post, if it is possible at all to open the damaged database, I would recommend creating a brand-new database and attempt to import objects from the OLD database, rather than trying to export to a new database. After being presented with this situation at least 15-20 times or more by now, it frequently seems that it ends up being usually one, maybe a couple, of objects that are actually corrupting the entire database.

During the import process within the new database, those objects that are outright corrupted will be flagged using a message box from Access, and it will usually attempt to continue importing any other objects that you had selected. Worst-case scenario is to import one object or a few objects at a time (which usually is a MAJOR pain), followed by a repair/compact on the new database each time. With that, it may help to do a backup on the new database every few objects or so as an insurance.

Hope that helps at least a little. Not a pretty solution, but I've been successful with it most of the times in the past.





Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Access VBA Dateddiff Function SKZ Access VBA 5 November 18th, 2008 08:38 AM
List Box Fliter MS Access VBA hewstone999 Access VBA 1 February 29th, 2008 09:01 AM
Events with VBA & MS Access hoen VB How-To 0 January 19th, 2006 10:18 PM
Emailing from MS Access using vba and outlook katd007 Access VBA 0 July 8th, 2004 12:48 PM
MS Access, VBA code to copy recordset Ivan Classic ASP Databases 1 November 1st, 2003 05:52 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.