• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

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

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
cycledude
Asked:
cycledude
1 Solution
 
käµfm³d 👽Commented:
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
 
cycledudeAuthor Commented:
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now