Compact and repair database

[JA]

I want to apply the "Compact and Repair Database" function
to my MS Access database that is running my asp pages. Is
it safe, and will my connections not be affected by the
action?
Please advise.

 

[Mike Mueller]

I have not had any problems doing this in the past using
Access 2000

Mike

JA wrote:
: I want to apply the "Compact and Repair Database" function
: to my MS Access database that is running my asp pages. Is
: it safe, and will my connections not be affected by the
: action?
: Please advise.

 

[Webmaster]

JA,

If you have a decently sized MS Access DB you always want to run the
compare and compact after making changes. I run a DB for the Nationwide
Recruiting Plan for the United States Marine Corps that is well over a gig.
If it weren't for compare and compact, the thing would be over 2 gigs. It
will not damage any connections you currently have. It is BETTER to run
this now than have a fault in your DB later and wish you had run it.

Good Luck,
Carl

 

[MD Websunlimited]

Hi JA,

There should not be any problem with doing this and is recommend procedure on a recurring basis. Always make sure you have a back
up.

 

[Jim Buyens]

-----Original Message-----

I want to apply the "Compact and Repair Database"
function to my MS Access database that is running my asp
pages. Is it safe, and will my connections not be
affected by the action?

The only problem is that if you do this by:

1. Opening your Web in FrontPage.
2. Double-clicking the .mdb file.
3. Using Access on your desktop to compact and repair
the file.
4. Closing Access and returning to FrontPage.

then any updates that occurred on-line while you were
doing steps 2, 3, and 4 will be lost. That's because step
2 downloads a copy of the database, and step 4 uploads the
copy, replacing the "live" file.

For information on doing a compact and repair directly on
a Web site, refer to the following MSKB articles.

306287
HOW TO: Compact a Microsoft Access Database by Using
Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=KB;en-
us;306287

230501
HOWTO: Compact Microsoft Access Database via ADO
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;230501

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Thomas A. Rowe]

I would strong recommend that you export or download to the database to your
desktop, then run a the repair, and Not do it while logged into your site
via FP.

I have a client that does this, and it corrupt the database, whereas when he
does it on his desktop, and then re-uploads, he never has a problem.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================