Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2014-02-26
2
Medium Priority
?
408 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 1500 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction Although it is an old technology, serial ports are still being used by many hardware manufacturers. If you develop applications in C#, Microsoft .NET framework has SerialPort class to communicate with the serial ports.  I needed to…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

963 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