By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,061 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

Failure to compact/repair: why?

P: n/a
I have a C++/OleDB project that is compacting an access db on-the-fly. I
close all my sessions, and close the DB. When I call IJetCompact::Compact(),
I get back E_FAIL. The same file, when pulled in to Access, will compact
just fine from the IDE. I do not have a failure record in the database after
a failure is recorded. I am using Jet 4.0.

Any idea what is happening??

RDeW
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
For Google's edification, the problem was that I did not know I had a
session open on the DB at the time.

If you cannot open a DB exclusively, you cannot compact it.
"Riley DeWiley" <ri***********@gmail.com> wrote in message
news:3v********************@seanet.com...
I have a C++/OleDB project that is compacting an access db on-the-fly. I
close all my sessions, and close the DB. When I call
IJetCompact::Compact(), I get back E_FAIL. The same file, when pulled in to
Access, will compact just fine from the IDE. I do not have a failure record
in the database after a failure is recorded. I am using Jet 4.0.

Any idea what is happening??

RDeW

Nov 13 '05 #2

P: n/a
For Google's edification, the problem was that I did not know I had a
session open on the DB at the time.

If you cannot open a DB exclusively, you cannot compact it.
"Riley DeWiley" <ri***********@gmail.com> wrote in message
news:3v********************@seanet.com...
I have a C++/OleDB project that is compacting an access db on-the-fly. I
close all my sessions, and close the DB. When I call
IJetCompact::Compact(), I get back E_FAIL. The same file, when pulled in to
Access, will compact just fine from the IDE. I do not have a failure record
in the database after a failure is recorded. I am using Jet 4.0.

Any idea what is happening??

RDeW

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.