Issue 24878 - table column *lost* when editing MS Access table
Summary: table column *lost* when editing MS Access table
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
Depends on:
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: ---

database to reproduce the bug case (83.10 KB, application/x-compressed)
2004-01-28 08:29 UTC, Frank Schönheit
no flags Details

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

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
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