Re: [libreoffice-users] BASE : How add data without primary key

[Toki Kantoor]

On 07/15/2013 11:26 AM, Wolfgang Keller wrote:

> In fact it's such a sick idea not to define one that sane RDBMSs don't even 
> allow it.

What else would you expect from The Jet Database Engine?

jonathon
-- 
LibreOffice in a Multi-Lingual Environment.

-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] BASE : How add data without primary key

[Wolfgang Keller]

> I want save my time.

Not defining a primary key *will* cost you a *lot* of time.

In fact it's such a sick idea not to define one that sane RDBMSs don't
even allow it.

Sincerely,

Wolfgang

-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] BASE : How add data without primary key

[Jean Milot]

Hi,

In the mdb file, i have a lot of forms ...

I haven't make this file and we will use only libreoffice not MS Office.

Thanks.

Sincerely,

Jean


2013/7/15 Regina Henschel 

> Hi Jean,
>
> Jean Milot schrieb:
>
>> Hi,
>>
>>
>> I want save my time.
>>
>
> Setting the primary key on table import is 1 click. Avoiding it does not
> save time, but produces trouble.
>
>
>  I don't want modify all the tables.
>
> ?? I thought you want to write data?
>
>
>
>> I have a mdb file, so i need already to create all the form so i f i can
>> use all the table without modifications.
>>
>
> If you will keep the mdb file untouched, you can do this:
>
> (1) Make a copy of the mdb file and connect to this copy.
> (2) Connect to the mdb file and then drag the table to a new database
> using the embedded hsqldb.
> (3) Export the access table into Excel format and use it in Calc or import
> it to a new hsqldb.
> (4) Export the access table into dBase format and connect to this dBase
> table.
> (5) Export the access table into a csv table and use this as text table in
> hsqldb (requires SQL).
>
> You need to tell in more details what you really want to do and why you do
> not simple connect to the mdb file, see option (1).
>
>
> Kind regards
> Regina
>
> --
> To unsubscribe e-mail to: 
> users+unsubscribe@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
>



-- 
MILOT Jean
Tél. : 0659514624
milot.j...@gmail.com

-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] BASE : How add data without primary key

[Regina Henschel]

Hi Jean,

Jean Milot schrieb:

Hi,

I want save my time.


Setting the primary key on table import is 1 click. Avoiding it does not 
save time, but produces trouble.


 I don't want modify all the tables.

?? I thought you want to write data?



I have a mdb file, so i need already to create all the form so i f i can
use all the table without modifications.


If you will keep the mdb file untouched, you can do this:

(1) Make a copy of the mdb file and connect to this copy.
(2) Connect to the mdb file and then drag the table to a new database 
using the embedded hsqldb.
(3) Export the access table into Excel format and use it in Calc or 
import it to a new hsqldb.
(4) Export the access table into dBase format and connect to this dBase 
table.
(5) Export the access table into a csv table and use this as text table 
in hsqldb (requires SQL).


You need to tell in more details what you really want to do and why you 
do not simple connect to the mdb file, see option (1).


Kind regards
Regina

--
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] BASE : How add data without primary key

[Jean Milot]

Hi,

I want save my time. I don't want modify all the tables.

I have a mdb file, so i need already to create all the form so i f i can
use all the table without modifications.

Thanks

Sincerely,

Jean


2013/7/15 Regina Henschel 

> Hi Jean,
>
> Jean Milot schrieb:
>
>  Hello,
>>
>> I search to use some tables from Access so i want to copy all data in base
>> ( i don't want to connect to the access db).
>>
>> How i can add data without create a primary key ?
>>
>
> Why do you want to avoid using a primary key?
>
> Do you know the database tutorial? See "LibreOffice Base Handbook" on
> https://wiki.**documentfoundation.org/**Documentation/Publications
>
> Kind regards
> Regina
>
> --
> To unsubscribe e-mail to: 
> users+unsubscribe@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
>



-- 
MILOT Jean
Tél. : 0659514624
milot.j...@gmail.com

-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] BASE : How add data without primary key

[Regina Henschel]

Hi Jean,

Jean Milot schrieb:

Hello,

I search to use some tables from Access so i want to copy all data in base
( i don't want to connect to the access db).

How i can add data without create a primary key ?


Why do you want to avoid using a primary key?

Do you know the database tutorial? See "LibreOffice Base Handbook" on 
https://wiki.documentfoundation.org/Documentation/Publications


Kind regards
Regina

--
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] BASE : How add data without primary key

[Jean Milot]

Hello,

I search to use some tables from Access so i want to copy all data in base
( i don't want to connect to the access db).

How i can add data without create a primary key ?

Thanks.

Sincerely,

Jean Milot

-- 
MILOT Jean
Tél. : 0659514624
milot.j...@gmail.com

-- 
To unsubscribe e-mail to: users+unsubscr...@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