Issue 54168 - Create table without primary key
Summary: Create table without primary key
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m125
Hardware: All All
: P2 Trivial with 4 votes (vote)
Target Milestone: ---
Assignee: requirements
QA Contact: issues@dba
Depends on:
Reported: 2005-09-02 17:59 UTC by computerhotline
Modified: 2009-07-28 21:42 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description computerhotline 2005-09-02 17:59:17 UTC
Follow these step :
 . Create a new database
 . Cick on "Tables" item
 . Doubleclick on "Create table in design view..."
 . Type "test" in first columns
 . Under, type "test2" in first columns
 . click on "File" -> "Save" -> OK
 . At the question about primary key, answer "no"
 . Close the table
 . Reopen the table previous created.
BUG : impossibility to enter data in table
Comment 1 christoph.lukasiak 2005-09-12 11:07:11 UTC
right, in the moment not possible because oo needs the 'explicity' of the row
(primary key or bookmarking like in access or dBase)

=> not a bug, but change in feature and send to requirements
Comment 2 jondoe 2005-09-21 21:04:20 UTC
Access does not require the creation of a primary key.  There may be some kind
of primary key created in the background by the software if a primary key is not
created by the user.  I really don't know, but if that is the case, it is
completely transparent to the user.

Primary keys can also be created and removed in existing tables in Access
without the tables being adversely affected (tables can still be edited).
Comment 3 martinkozak 2006-01-31 17:42:26 UTC
Exactly, this would be well to fix also because of users who switch from 
Microsoft Access to Base.


Martin Kozák
CS User Support Leader

Comment 4 leggewie 2008-09-25 19:52:01 UTC
Is this still an issue?  I don't think I experienced this in OOo2.
Comment 5 Mechtilde 2009-07-28 17:07:12 UTC
IMO for Base as a frontend of different database management systems it is right
to need an primary key and didn't it automatically.

and IMO it is a Bug that MS Access doesn't do it.

so works as designed -> invalid
Comment 6 Mechtilde 2009-07-28 21:42:59 UTC
-> closed