Solved

c# winforms 2010 'compact and repair' access database without DAO

Posted on 2014-02-26
2
394 Views
Last Modified: 2014-03-03
Hi

I have come across a situation where having a reference to DAO in my application  is causing problems at design time (https://secure.experts-exchange.com/Programming/Languages/C_Sharp/Q_28374832.html)

Is there any way to programatically compact and repair an access database without using DAO?
0
Comment
Question by:cycledude
2 Comments
 
LVL 75

Accepted Solution

by:
käµfm³d   👽 earned 500 total points
ID: 39889033
I don't know if it would be feasible in your project, but you could use the command line to do so. The "/compact" switch will trigger a compact-and-repair on the database file. You could use the Process class to execute such.
0
 

Author Closing Comment

by:cycledude
ID: 39902536
after a little more digging, it looks like DAO is the best way to compact a database, especially as it does not require the end users to have access installed.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a simple method to resize a control at runtime.  It includes ready-to-use source code and a complete sample demonstration application.  We'll also talk about C# Extension Methods. Introduction In one of my applications…
We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now