Re: CompactDatabase



ghigno wrote:
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.


Sorry, but you'll probably have more success asking in a newsgroup
devoted to Access. I don't even know what "attachments" are, and I
vaguely remember reading something about multi-value fields ...
Maybe there's an updated version of the JRO library you need to obtain
....

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.



Relevant Pages

  • CompactDatabase
    ... i'm tying to compact an access2007 db with CompactDatabase ... jet.CompactDatabase (srcConn, dstConn); ... Database uses attachments or multivalor fields. ...
    (microsoft.public.data.oledb)
  • 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: Some messages being lost...Looking for a tool
    ... "update" didn't touch OE or where the folders are set up, ... Well after I download 200 messages in a newsgroup I ... > to avoid the Compact all folders and prefer to manually ... > servers seem to handle things a heck LOT better. ...
    (microsoft.public.windowsxp.general)
  • Re: Some messages being lost...Looking for a tool
    ... "update" didn't touch OE or where the folders are set up, ... Well after I download 200 messages in a newsgroup I ... > to avoid the Compact all folders and prefer to manually ... > servers seem to handle things a heck LOT better. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Something changed Mac-PB
    ... My original post and list was a newsgroup post double clicked to fully open. ... I see the same here, except for the "Reply To" line, with All Headers enabled or disabled; the gray toolbars section takes up maybe 10% of the message window in my layout. ... 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". ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)