To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82124 Issue #|82124 Summary|Copy table wizard creates mishandles MS Access COUNTER | field Component|Database access Version|current Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen
------- Additional comments from [EMAIL PROTECTED] Mon Oct 1 02:45:52 +0000 2007 ------- The problem is when an MS Access table uses a COUNTER field ( INTEGER AUTO_INCREMENT ) that is not part of the key and there is a PK on the table, based on a different field. When the Copy table wizard generates the CREATE TABLE statement it uses an IDENTITY for the COUNTER field and also add the PRIMARY KEY constraint to the other field's definition. See the attached error message for the actual SQL statement generated when only the two fields are used for the table definition. Note - this is when the MDB file is attached using the MS Access database type - if you use ODBC to connect instead the problem does not happen, because it does not see the PRIMARY KEY at all. In this case the Copy Table Wizard still creates the IDENTITY field, but does not create the PRIMARY KEY constraint, so the create table statement does not fail. However, the table created in Base is not the same as the table in MS Access any longer. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
