Re: [libreoffice-users] Re: Can't add new tables - error msg

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