Compact and repair db question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Flick Olmsford <FlickOlmsford@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 21 Oct 2008 07:58:00 -0700

I am running Access 2003 on Windows Server 2003 / Windows XP SP2
workstations. I run the compact and repair option but the database does not
change size and I am left with a new file in the folder called db1, which is
a bit smaller.

Did the compact and repair fail or did it succeed and I just need to rename
the db1 file to the database?

I did not have to do this before.
.

Follow-Ups:
- Re: Compact and repair db question
  - From: John W . Vinson

Prev by Date: Unsure how to link tables
Next by Date: Add the column using DDL
Previous by thread: Unsure how to link tables
Next by thread: Re: Compact and repair db question
Index(es):
- Date
- Thread

Relevant Pages

Re: Compact and repair db question
... I run the compact and repair option but the database does not ... change size and I am left with a new file in the folder called db1, ... Did the compact and repair fail or did it succeed and I just need to rename ...
(microsoft.public.access.tablesdbdesign)
Re: How do I automate repair on close?
... More recent versions of Access have a Compact & Repair option on close -- ... <Access MVP> ... > The database tables compact at night but I want the database to repair as ...
(microsoft.public.access.modulesdaovba)
RE: Compacting MDB help
... The autoexec macro opens a ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ... I'm quite certain that you can't Compact an open database from within itself ...
(microsoft.public.access.modulesdaovba)
RE: Compacting MDB help
... This will cause the database to grow so Compacting ... not split off the tables from your FrontEnd. ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ...
(microsoft.public.access.modulesdaovba)
RE: Compacting MDB help
... not practical to have staffpersons open another database in order to switch ... When the front end opens, it goes directly to the main switchboard. ... the only reason why you would need to Compact the ...
(microsoft.public.access.modulesdaovba)