Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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 June 26th, 2003, 06:56 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 231
Thanks: 0
Thanked 0 Times in 0 Posts
Default Compress and Repair Damaged Database

When you need to repair a damaged or corrupted database, in which order should you compress and repair?

For example, should the compress be done first followed by the repair, or is it the other way round, or should you compress, repair and then compress again?

Regards
Owain Williams
__________________
Regards
Owain Williams
 
Old June 26th, 2003, 07:28 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 231
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I forgot to mention, it is an Access 97 database that I am accessing through Microsoft Jet 3.51

Regards
Owain Williams
 
Old June 26th, 2003, 08:18 AM
Authorized User
 
Join Date: Jun 2003
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Make a back up and then try it both ways. If that doesn't work, there are other applications that will repair an MDB.

Regards,
Mike
 
Old June 30th, 2003, 04:45 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 231
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for you suggestions. I was wondering if you or anyone could provide some more information on applications that repair Jet databases. The client with the damaged database does not have Access installed, so he can not use the Compact and Repair Database facility.

Regards
Owain Williams
 
Old June 30th, 2003, 05:55 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

Owain,

See my off-topic reply to your off-topic post in the SQL Language forum. :D

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
Compact and Repair Access Database raguapk VB How-To 8 May 23rd, 2013 10:00 AM
PDF report...does not open ,shows file damaged Namita Crystal Reports 2 April 29th, 2008 07:04 AM
Compact/Repair Access Database On The Fly kevorkian Classic ASP Databases 3 November 22nd, 2004 06:57 PM
Compact And Repair Access Database myedu2k4 Pro VB Databases 1 May 25th, 2004 01:43 AM
How to compress a Database ? darkdog SQL Server 2000 3 June 20th, 2003 03:20 PM





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