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

2012-08-27 Thread Andreas Säger
Am 27.08.2012 18:59, hover2gb wrote: SOLVED - I figured out how to modify the script and then just archive it back into the database with a ZIP program. And it worked. I now have access to all of my data, and everything works perfectly. Thanks, thanks, THANKS! -- View this message in contex

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

2012-08-27 Thread Dan
hover2gb wrote: 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 datab

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

2012-08-27 Thread hover2gb
SOLVED - I figured out how to modify the script and then just archive it back into the database with a ZIP program. And it worked. I now have access to all of my data, and everything works perfectly. Thanks, thanks, THANKS! -- View this message in context: http://nabble.documentfoundation.or

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

2012-08-27 Thread hover2gb
>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 scri

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

2012-08-27 Thread Andreas Säger
Am 27.08.2012 16:34, hover2gb wrote: Andreas, 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.

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

2012-08-27 Thread hover2gb
http://nabble.documentfoundation.org/Cannot-access-my-database-file-tp4003433p4003846.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubs

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

2012-08-27 Thread hover2gb
Andreas, 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

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

2012-08-26 Thread Andreas Säger
You must not embed images in your embedded database. Any form with a picture control will try to load the whole field. I think this is the true bug in this affair and it was sitting there ever since. Use a text field with relative links to picture files. Bind a form's picture control to the text

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

2012-08-25 Thread Alexander Thurgood
Le 24/08/12 21:34, hover2gb a écrit : Hi, > It may help for me to mention that I only added 2 images to the DB before I > began having issues. And the images were 1.7MB and 7 MB, so only a total of > 8.7MB. I wouldn't think this should create any kind of memory issue > No, this shouldn't have

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

2012-08-24 Thread hover2gb
It may help for me to mention that I only added 2 images to the DB before I began having issues. And the images were 1.7MB and 7 MB, so only a total of 8.7MB. I wouldn't think this should create any kind of memory issue -Greg -- View this message in context: http://nabble.documentfoundation.

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

2012-08-24 Thread hover2gb
Dan, Thanks. I have just attempted to do everything you mentioned, but it does not seem to help. For what it's worth, I forgot to mention that I am on a MAC, so I access the settings through the Preferences menu, but everything appears the same once inside. I changed all settings to your recomm