469,920 Members | 2,190 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,920 developers. It's quick & easy.

Failure to compact/repair: why?

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
2 1619
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
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.

Similar topics

6 posts views Thread by KEVIN97810 | last post: by
4 posts views Thread by Wayne | last post: by
4 posts views Thread by zufie | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.