| Summary: | Content of memo fields in MS Access tables get truncated in LibreOffice Base forms. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Albrecht Müller <albrecht.mueller> |
| Component: | Database | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEEDINFO --- | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | CC: | albrecht.mueller, iplaw67, lionel, todventtu |
| Version: | 4.2.4.2 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| i915 platform: | i915 features: | ||
|
Description
Albrecht Müller
2014-05-21 17:13:56 UTC
Hi Albrecht, Do you have a Database > Advanced Properties context menu when you right mouse button click on a table in the main ODB window ? This might be database type dependent, I don't remember anymore. If you do have access to such a menu entry, you should be able to set the form to not verify that the data entered in the form corresponds to that required for the bound fields. Untick that box, and see whether that changes anything. If not, this does sound like a duplicate of a previous bug entry, but I don't have the number to hand. Alex Maybe the problem here is similar/same, and perhaps specific to Windows : https://bugs.freedesktop.org/show_bug.cgi?id=65644 Hi Alex, After I switched the user interface language to English (UK) I found: right click to some object (can be a table or a form) -> Database -> Advanced Settings -> Form data input checks for required fields. The corresponding check box was checked and I unchecked it. I was not able to notice a difference. When I close a form showing truncated content I sometimes get a dialog box asking me I a want to save the changed record. I have got the impression that this message does not appear if I just navigated to some record containing truncated content. If I had set the focus into the control containing the truncated content (without changing anything) the dialog appears when I close the form. It is complicated to assess when changes to the database occur as the table view seems not to reflect these changes immediately, i.e. I have to close and reopen the table view if want to see current content of database. I don't think this is a duplicate of 65644 as this bug is related to version LibreOffice 4.0.3.3. My problem in related to Access 97 databases, and to my knowledge the Access2Base feature is not included in versions before 4.2. (see http://www.access2base.com/access2base.html) Using previous versions I had no easy way to connect to MS Access databases. The behavior of this bug seems to have changed between versions 4.2.3.3 and 4.2.4.2: In version 4.2.3.3 memo fields were truncated in the table view. In 4.2.4.2 the table view shows the full content. (I don't have 4.2.3.3. installed now therefore I cannot verify this observation again). Both versions are unable to display the full content in forms. I think this bug is really dangerous as it makes it very easy to inadvertently destroy database content. Albrecht Albrecht: can you test with 4.3 and 4.4 beta and report your results here? Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away. (In reply to Beluga from comment #4) > Albrecht: can you test with 4.3 and 4.4 beta and report your results here? > Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED > WORKSFORME, if the problem went away. Tried with Version: 4.3.4.1 Build ID: bc356b2f991740509f321d70e4512a6a54c5f243. Unfortunately this is the only version available to me. The behaviour persists. What I did: Using Base, I opened an MS-Access97 database, created some form (I used one that shows a single record per page) on a table containing memo fields, navigated to some record containig a field with content longer than about 255 characters, moved cursor to the end of the field (was careful - tried a avoid changing any content), saw that content was missing, quit the form. Got prompted if I wanted to save the changed content (I did not change anything!), confirmed this, used a MS-Access installation to see that the content is actually truncated. Summary: There is a substantial loss of data. Let's set to UNCONFIRMED then. Unless we have a test Access97 file with which to test, it is going to be difficult for any of the qa team to reproduce. What type of control is being used in the form to show? Text box? Formatted field? Do you use ODBC or ADO to connect to the .mdb file? (If you attach the .odb file, that would be nice.) (In reply to Albrecht Müller from comment #3) > My problem in related to Access 97 databases, and to my knowledge the > Access2Base feature is not included in versions before 4.2. Access2Base is only about running Basic macros, that's unrelated to accessing *data* in .mdb files. The latter is available since OO.org times. Adding self to CC if not already on (In reply to Alex Thurgood from comment #7) > Unless we have a test Access97 file with which to test, it is going to be > difficult for any of the qa team to reproduce. Hello Albrecht, Please send us a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document. (Please note that the attachment will be public, remove any sensitive information before attaching it.) How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F Thank you |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.