[AccessD] corrupt database - backup rather out-dated.

Gary Kjos garykjos at gmail.com
Mon Jun 2 12:55:36 CDT 2014


Well corruption can happen in all versions. I wouldn't personally blame
2013 version for your issues just yet. Could be. I just started using 2013
a couple weeks ago. I still create all my databases in 2000 format. I'm not
creating anything for distribution to others though.

I'd recommend you get a backup strategy/habit in place. Copy the file to a
ZIP file every day and copy that someplace other than the hard drive where
you are working or something like that. Loosing work during development is
never a good thing although I have found that sometimes being forced to
redo some things can lead to them being done in better ways the second time
through.

When I was developing databases for others with a lot of code I would
rename my work in progress database every day so I could always go back to
yesterdays version. Eventually I would have a dozen versions sometimes and
then I would delete all the early versions once I was sure I didn't need
them.

I also would make copies to other media or other systems too in case I had
a drive crash.

You can not have too many backups.

GK



> On Mon, Jun 2, 2014 at 12:37 PM, Bill Benson <bensonforums at gmail.com>
> wrote:
>
>> Thanks Jim.
>>
>> I am fortunate to learn of this problem early. I have never had this
>> happen
>> in earlier versions (2010 on back to 97) and I don't think this bodes well
>> for my love of 2013. I will probably put 2010 back and uninstall 2013.
>> On Jun 2, 2014 8:00 AM, "Jim Dettman" <jimdettman at verizon.net> wrote:
>>
>> >
>> >  Unfortunately Microsoft never updated the JETCOMP.EXE tool for the
>> .accdb
>> > format.
>> >
>> >  It was the only tool that would work (sometimes) in situations like
>> this
>> > because unlike the compact and repair, it would not open the DB as a DB
>> > first, but treat it just like as a file and repair the DBH (Database
>> > Header)
>> > page first, then open the DB.
>> >
>> >  If you can't open it, you don't have any options other than a recovery
>> > service out on the net.
>> >
>> > Jim.
>>
>>
-- 
Gary Kjos
garykjos at gmail.com


More information about the AccessD mailing list