CompactDatabase

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

hi all,
i'm tying to compact an access2007 (.accdb) db with CompactDatabase
method

i use "provider=Microsoft.ACE.OLEDB.12.0" driver

srting srcConn = provider+ "Data Source" + pathFileName + ";Jet
OLEDB:Engine Type=5"
JRO.JetEngine jet = new JetEngine();
jet.CompactDatabase ( srcConn, dstConn); // dstConn is similar than
srcConn less engineType

but an error occours qhen i'm trying to compact a database that has
some attachments inside...

code error: 2147467259
Message: (-> traduction from italian ) Unable to complete opration.
Database uses attachments or multivalor fields.

please help me... this error makes me crazy...
.

Relevant Pages

  • Re: CompactDatabase
    ... i'm tying to compact an access2007 db with CompactDatabase ... jet.CompactDatabase (srcConn, dstConn); ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • CompactDatabase
    ... i'm tying to compact an access2007 db with CompactDatabase ... jet.CompactDatabase (srcConn, dstConn); ... Database uses attachments or multivalor fields. ...
    (microsoft.public.data.ado)
  • Re: Do you want to open this file - mail attachment - dialog box gone
    ... I haven't tried all types of attachments, but it's doing it for EXCEL and ... Assuming all is well, compact all folders in the old identity, ... OE just opens the file directly. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Cannot Send Attachments
    ... Move them to local folders created for this purpose. ... Disable Background Compacting and frequently perform a manual compact of all OE folders while "working offline". ... WinXP SP2 only: Do not shut down your machine while Windows is automatically compacting your message store. ... one and just discovered that I cannot send mail with attachments. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Where does OE store email attachments?
    ... - Don't use Inbox or Sent Items to archive messages. ... Move them to local folders created for this purpose. ... compact of all OE folders while "working offline". ... to search the attachments for a specific file. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)