https://bugs.documentfoundation.org/show_bug.cgi?id=148367
--- Comment #8 from Mike Kaganski <[email protected]> --- Created attachment 195559 --> https://bugs.documentfoundation.org/attachment.cgi?id=195559&action=edit An empty Access database How can this bug be tested? There is no accdb test file here. With my own generated data, I see no problem: 1. Using Windows ODBC 64-bit applet, add a new user DSN; choose Microsoft Access Driver (*.mdb; *.accdb); on the ODBC Microsoft Access Setup page, click [Create...] and choose where to save the new accdb file. I attach an empty such file. 2. In LibreOffice, create a new ODB connected through ODBC to this DSN. 3. In LibreOffice Base, use Tools->SQL, and run these SQL commands: CREATE TABLE noPrimaryKey ( [str] VARCHAR ); CREATE TABLE hasPrimaryKey ( [id] INT NOT NULL PRIMARY KEY, [str] VARCHAR ); Note that they should be executed separately. Also note that [x] Show output of SELECT statements should be checked, otherwise you will see an error instead of success (but the table will be created). 4. Refresh tables (or reopen database), and try to edit tables. Both tables are editable for me using Version: 24.8.0.1 (X86_64) / LibreOffice Community Build ID: 6fd6cae02baed1e82d14ed2da1f2458092354dab CPU threads: 24; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Vulkan; VCL: win Locale: en-US (ru_RU); UI: en-US Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.
