To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72263 Issue #|72263 Summary|Can't copy tables without PK Component|Database access Version|OOo 2.0.4 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ordimars
------- Additional comments from [EMAIL PROTECTED] Mon Dec 4 10:36:33 -0800 2006 ------- Hi, I have tryed to copy tables from a Base file linked to a MS Access database to another Base file linked to a PostgreSQL database. That worked well (sort of) as long as there were no int columns: it seems the definition of colums type do not work that well. The type proposed for all chars is name and it never possible to change the length of the column. But it works: even importing zero length colums works ! ? ! The problem occurs when importing integer colums: when not importing them it worked fine. To import them, even though the column type was correct, it would not work ! Till I copied the table in the same db, meaning in the same file (MS-Access) from Currencies to Currencies2, and on that occasion creating a new column as Primary Key as requested. Then I could copy this new table (Currencies2) into my PostgreSQL Base file ! The MS Access DB used can be found at : http://www.unece.org/etrades/download/files/cucod_r0410.mdb --------------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]