#14 Shuffled columns from Jet4

open
nobody
None
5
2003-01-17
2003-01-17
Anonymous
No

mdbtools seem to occasionally shuffle the columns in a
Jet4 (Access2002) database around so that the content
does not fit with the column headings.

Say, the columns are:

GKZ,GENAME,ST1,ST2,PLZ,STRSCHL,STRNAME,HNRVON,ZUSVON,HNRBIS,ZUSBIS,NRART,BEV,PROBLEM

exported from Access to Access97-format, mdbtools gets
it right:

"00000000","Einestadt","Kernstadt",1.000000,"","","Hafenstr.","","","","","","",""

while the same entry from the Access2002 database is
seen by
mdbtools as:

"00000000","Einestadt,1.000000,"","","Hafenstr.","","","","","","","","Kernstadt"

Looks like column three has jumped to the last position.

mdb-schema seems to have the same problem, since it
reports the third column as Double (8), which is not
compatible with the correct value "Kernstadt".

If I copy the offending table into a new database,
mdbtools exports it correctly, so I am not able to
include a test case.

Yours, Florian Hars (hars@bik-gmbh.de)

Discussion

  • Daniel Austin

    Daniel Austin - 2003-04-09

    Logged In: YES
    user_id=183517

    I was having the same problem. At Brian Bruns's suggestion I
    tried compacting the database (avail from the Access Tools
    menu). This actually fixed the problem.

     
  • Nobody/Anonymous

    Logged In: NO

    simular fault within a larger table with serveral column names
    containing spaces, boolean field, and larger char fields. mdb-
    sql returned results from column X when query for column Y.
    This is mighty dangerous as it may cause leakage of private
    information.

    describe table also showed incorrect field types against their
    names. upon shift the field name orders in access and saving,
    mdb would show the shift in names, but not in field types.
    these two problems may be related.

     
  • Alexandre Horst

    Alexandre Horst - 2004-07-28

    Logged In: YES
    user_id=799194

    I have the same problem. If you create a Table with 4
    columns with Text, inserted some data and removed 2 columns,
    you will see the data shuffled in gmdb.

     
  • Luciano Miguel Wolf

    Logged In: YES
    user_id=1073620

    I posted a patch that corrects this in Jet4 databases.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks