Issue 24878

Summary: table column *lost* when editing MS Access table
Product: Base Reporter: Frank Schönheit <frank.schoenheit>
Component: codeAssignee: Frank Schönheit <frank.schoenheit>
Status: CLOSED FIXED QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1   
Target Milestone: OOo 2.0   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
database to reproduce the bug case none

Description Frank Schönheit 2004-01-28 08:14:26 UTC 
system: WinXP, service pack 1, MDAC 2.8, msjetoledb40.dll version: 4.0.8015.0

* create a data source for the attached bugdoc.mdb
* Tools|Data Sources
* select the data source, and go to the tab page "Tables"
* select the table "test"
* press the "edit table" button in the toolbox of this tab page
=> the table design opens
* there's a column named "test" - change it's type to "Integer [long]"
* save the table
=> a warning pops up, saying that the column could not be changed, and asking
whether it should be deleted and re-appended
* press "no"
=> the type of the column "test" is changed back to "Text [LongText]" (which is ok)
* close the table design window
* reopen it
=> the column "test" vanished from the table (including all potential data, of
course)

FS: targeting to 1.1.2 in agreement with MSC
FS->OJ: please also investigate why the warning pops up at all - shouldn't ADO
be able to change column types without any problem?
Comment 1 Frank Schönheit 2004-01-28 08:29:56 UTC 
Created attachment 12760 [details]
database to reproduce the bug case
Comment 2 hans_werner67 2004-02-02 12:16:02 UTC 
change subcomponent to 'none'
Comment 3 thorsten.ziehm 2004-03-09 10:15:22 UTC 
Because of limited resources we have decided to set this task to OOo2.0.
Comment 4 ocke.janssen 2004-05-12 08:01:25 UTC 
Fixed in cws insight01

Doesn't occur any more.
Comment 5 marc.neumann 2004-06-15 14:28:36 UTC 
reopen
Comment 6 marc.neumann 2004-06-15 14:28:56 UTC 
reassign to fs
Comment 7 marc.neumann 2004-06-15 14:29:18 UTC 
fixed in cws insight01 -> please verify
Comment 8 Frank Schönheit 2004-06-17 11:57:08 UTC 
verified in CWS insight01 - submitted follow-up issues:
- issue 30381: table column in MS access database cannot be saved - data lost when
  changing table structure
- issue 30382: when editing a table, the preview should be switched
(temporarily) switched off
Comment 9 Frank Schönheit 2004-06-17 11:57:54 UTC 
now really marking VERIFIED
Comment 10 Frank Schönheit 2004-12-30 08:51:20 UTC 
fix verified in 680 m66