To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116509
User r4zoli changed the following: What |Old value |New value ================================================================================ Assigned to|dbaneedsconfirm |oj -------------------------------------------------------------------------------- Ever confirmed| |1 -------------------------------------------------------------------------------- Status|UNCONFIRMED |NEW -------------------------------------------------------------------------------- ------- Additional comments from r4z...@openoffice.org Thu Feb 3 15:17:09 +0000 2011 ------- I confirm it I found similar or same problem with different MS drivers to MS accees files fails with ADO, and mdb driwer works with ODBC. I investigated with other MS connected product and find that the mdb driver for msaccess nwind.mdb example file has a same problem, with first records. Download Northwind example file, unpack it: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=C6661372-8DBE-422B-8676-C632D66C529C&displaylang=EN Create connection to this nwind.mdb file through New>database>connect to existing database>Microsoft Access, open Product table -> Missing record to ProductID=1. The mdb driver recognize ProductID as Integer[long]and shows as PK. Same with ADO/JET connection. Create ODBC connection to same nwind.mdb file, Shows all records. The ODBC driver recognize ProductID as Integer[Counter] and not PK. This happens with latest DEV300m99 version, too. I found it when checked issue 115384, on win7. (where I copied table with two records, shows only one in mdb connected file). @fdany in your tables which ID types shows in OOo table edit mode with different drivers. --------------------------------------------------------------------- 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org