Issue 24878 - table column *lost* when editing MS Access table
Summary: table column *lost* when editing MS Access table
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: Frank Schönheit
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-01-28 08:14 UTC by Frank Schönheit
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
database to reproduce the bug case (83.10 KB, application/x-compressed)
2004-01-28 08:29 UTC, Frank Schönheit 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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