[libreoffice-users] Re: Cannot access my database file!

Am 27.08.2012 16:34, hover2gb wrote:
> Andreas,
>
> <You must not embed images in your embedded database. Any form with a
> &lt;picture control will try to load the whole field. I think this is the
> &lt;true bug in this affair and it was sitting there ever since.
> &lt;Use a text field with relative links to picture files.
> &lt;Bind a form's picture control to the text field. The pictures will be
> &lt;loaded one by one. >
>
> Thanks for the info.  I believe you are correct, but I do not know what to
> do now.  I am not able to open the table, form or anything to remove the
> embedded  image.  Can you help with this?
>
> -Greg
>
>
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Cannot-access-my-database-file-tp4003433p4003841.html
> Sent from the Users mailing list archive at Nabble.com.

Try Tools>SQL...
ALTER TABLE "TableName" DROP COLUMN "Pics";
SHUTDOWN COMPACT;
Execute, close and reopen the database document.

If this does not help, You can extract the script file out of the 
document archive, remove all references to that picture column and 
rebuild the database from script.


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted