Could you help me I want to compact and repair my accdb using C#?

Question

0.00/5 (No votes)

See more:

Please brothers I want to compress and repair my accdb database..

I search and found this code but I don't how to use it ?

C#

public static void CompactAndRepair(string accessFile, Microsoft.Office.Interop.Access.Application app)
        {
           string tempFile = Path.Combine(Path.GetDirectoryName(accessFile),
                              Path.GetRandomFileName() + Path.GetExtension(accessFile));

            app.CompactRepair(accessFile, tempFile, false);
            app.Visible = false;

            FileInfo temp = new FileInfo(tempFile);
            temp.CopyTo(accessFile, true);
            temp.Delete();
        }

Posted 27-May-15 0:31am

Abdullah96

Add a Solution

Comments

Andy Lanng 27-May-15 6:44am

looks pretty straight forward. whats the issue?

pass the file path and an application reference and it does the work for you.

I don't know your code. How can I say anything more.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2015-05-27T01:03:00

Include the code in your application, and call it from a Button Click event handler.
Pass it the full path (for example: @"D:\Temp\My Databases\MyDB.accdb") in the first parameter, and an instance of Access in the second:

C#

Microsoft.Office.Interop.Access.Application msAccess = new Microsoft.Office.Interop.Access.Application();

Wait. Probably a long time...

Frankie-C · Answer 2 · 2015-05-27T01:30:00

There is an article[^] on CodeProject that could help.
BTW the sample code you found need some more fixings. It copy your access database to a temporary file, then copy it back to the original file. But maybe you want to check if the database was successfully repaired before copying it back destroying even the original copy ...
And you may want to catch any exception to correctly handle the conversion.
Information about the CompactRepair() method can be found here[^].

Could you help me I want to compact and repair my accdb using C#?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0