Related Topics

Compact And Repair Macro?

Compact and Repair crashes on larger databases
When I try to run compact and repair on any database that is ~500MB or larger, Access crashes . It is pretty consistent on when it crashes. e.g. a DB that is 692MB crashes when the temp DB reaches 569MB.

Here is where it gets stranger. .problem happens on multiple databases and I can copy the DB to another computer with Access 2007 (Same version) and Compact/Repair works fine.

For problem / attempted corrections I have tried the following with no luck

Checkdsk - OK
Boot in Save Mode - Compact / Repair still crashes
Move DB to another HD on my computer (Thinking I may have disk failing) - Compact / Repair still crashes
Uninstall / Install Access - - Compact / Repair still crashes


Compact Repair BE
I've read quite a few posts on compact and repair but need some clarification.
I have a split database; how often should you compact the FE? How often should you compact the BE? I would like to run a batch file through task manager to trigger the back end compact late at night so no one can open it.
The back end has a security password set; when I do a command line compact repair in task manager it starts to work then stops at the password input box. How can I add this password to a batch file so it can complete the compact and repair. I see through the posts that you should back up the DB first. Can someone help me with the batch file to include a back up then compact the DB?


Data loss after compact & repair
I have just done a compact and repair on my Access database. Afterwards one of the tables has lost a lot of data (but only one?).

Spookily the table now has exactly 20000 records in it, which makes me think this is some kind of limit, except that I dont think there are table limits in Access and I have other tables in the database with more than this number of records that are still ok.

Questions:
Is there any way of recovering the data after a compact & repair?

Any ideas why the compact repair would have deleted these records? (It hasnt happenned with previous compact repairs)

I dont have a recent backup of the database, but thats a different problem!


Compact and repair on close
I inherited a multi-user database that is on a network drive. There are multiple front ends for people to use and they are all set up to compact and repair when they close out of the program. The problem I have been having lately is there have been a lot of DB1.MDB that show up along with the front door of the program. Should I turn off the compact and repair or should I leave it on


Compact and Repair Database
Is it possible to build a macro where you can compact and repair the database as one of the steps?


Problem in MS Access data update
I have a database it contains data more than 4 million line items but while I try to run macro or any query the database reaches the maximum limit of 2 gb , then the particular query not functioning and then I need to compact and repair. After compact and repair also the same issue is continuing.

Kindly help me in solving this issue else tell me some other solution to eliminate this issue and resolve it.


Compact and Repair an Access Runtime Application
I'm building a Runtime app in Access 2007 that will be run by many people who are quite INexperienced with computers, and will have even less experience with Access. Is there a SAFE way tocompact and repair an Access 2007 Runtime program?

I keep seeing warnings about using the automatic compact and repair in the Access Options of 2007. However, I'm worried about data bloat if this is never done.

Does anyone out there have experience with Access 2007 Runtime using the automatic compact and repair?


Compact and repair failure
My database is failing to compact and repair. The error message is "invalid argument". Background: using access 2000, and the db is very very large, 2,096,444KB. I'm pretty sure there is some type of 2GB limit.. I've exported the huge table elsewhere, and am trying to compact..but it won't. Another caveat is that some of the tables are local like this one, others are on a sql server.


Compact and Repair Database
In MS Access 2003 I used this code to compact and repair my database,

Public Sub CompactDB()

CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Compact and repair database.."). _
accDoDefaultAction
End Sub

But for some reason this doesn't work in MS Access 2007. That might be because MS Access 2007 does not have a Menu Bar.

How would I write the code to manipulate the menus in 2007 to compact and repair the database. This is a stand alone database.


Compact and Repair a Database
This procedure compacts and repairs a database, creates a log if there is any corruption in the source file, and returns a Boolean value based on whether the recovery was successful. Learn how to compact and repair a database.


Scheduling a Compact and Repair
Here's you will learn Scheduling a Compact and Repair. (video tutorial)


Scheduled run of Compact-Repair off hours
There should be a way to run an "auto-marco" as in Excel that does the Compact and Repair that can be put on an XP-Scheduler to run nightly.


Scheduled run of Compact-Repair off hours
There should be a way to run an "auto-marco" as in Excel that does the Compact and Repair that can be put on an XP-Scheduler to run nightly


Repair and Compact
Sir or Madame

Is the a System call in VBA that do the same thing or simillar
as the "Compact and Repair" that you can do manually in the
Access menue system ?

I would like to have the ms access client to do this every time it starts


Force a compact repair.
I have a database which is split into FE & BE, the BE is locked open by a forms server.
I have a way to force a close but have to contact someone to reopen it.
I would like to be able to code a compact and repair to run during the night ideally without having to close access.

Access 2000 by the way


Compress and Repair Once per month
Could do with some help here, not sure how to go about this. I'm a beginner at VBA and this is a little out of my league! Been seraching for a while but found nothing so far that could help me.

I would like my database to conpact and repair once per month automatically, however, the database runs on Windows Scheduler and uses an Autoexec macro each day. What I was going to do is get the macro to run the Compress code but only on the 1st day of each month. Only problem with that is, when it re-opens after the compacting, it will go to run the autoexec again, and start the compact again


Compact & Repair Bug
After using the compact and repair function manually from the manage tab of Access 2007, a glitch occurs where I cannot rename, delete or cut any of my objects (tables, forms, queries, etc). The options are greyed-out when I right-click on the object in the left object pane. Any way to rectify this issue so I don't have to backtrack to an earlier back-up of my database?


Help prevent and correct database file problems by using Compact and Repair
Database files can grow quickly as you use them, sometimes impeding performance. They can also occasionally become corrupted or damaged. You can use the Compact and Repair Database command in Microsoft Office Access to prevent or fix these problems.


compact and repair database causes inaccuracy of data
My database reached 2 gigs fo memory. So I clicked compact and repair which shrunk it down to 200 mb. But now when I run query, it only returns 5 records, for example, when it should at least be returning 50. It was pretty close to accurate and now it is completely inaccurate. The queries didn't change. And I reimported my list of records after deleting the old list. But the inaccuracy still persists


Database suddenly bloated - Compact and repair has little effect
I am mid-way through a database system and suddenly today, its size has increased tremendously. It was 12-13 MB till yesterday and today, it is 230 MB. Also,

I tried Compact and repair but it only decreased the size by 2-3 MB. I also decompiled it and it had no effect.