Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


You may need to re-create the database in something neutral that both Access
and Lo Base can read,  like MYSQL.
On Apr 12, 2011 3:38 AM, "Alexander Thurgood" <alex.thurgood@gmail.com>
wrote:
Le 10/04/11 05:06, us90na a écrit :

Hi,

I developed a database in Access and "connected" then saved it into Base.
I
can read my tables but when I go to add a new table I get the error
"Could
not append colum: invalid column descriptor."

And when I click OK I get, "Error while saving the table design. Invalid
field definition "id' in definition of index or relationship"


You would need to tell us what the definition of your table is in order
for us to be able to try and help you. That error message points to the
use of a field type as the index field that LibreOffice doesn't accept.
This may also be why your table structure defaults to read only. For
example, do you have multiple fields as a single index ? If so, are they
of different types (eg. a combination of CHAR and INT) ? Or, do you have
a FK relationship that points to multiple or combined indices (I don't
think LibO Base can handle these) ?


FWIW, from what I have read elsewhere, you can not alter the structure
of an existing table in an Access MDB via LibreOffice.

Alex


--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be
deleted


-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.