Access 97 to Access 2003 database conversion

Discussion in 'Microsoft Access' started by Jacques Trépanier, Aug 29, 2007.

  1. Hi,

    We work in a mostly french environment. We have a standard image using MUI
    Microsoft products (XP and Office 2003 are MUI) Since the convertion of an
    ACCESS 97 BD into Access 2003, we experience a sort sequence problem when
    using:

    DoCmd.Openform or DoCmd.ApplyFilter

    A selection on a name like "Coté" will return no record. Asking for "Cote"
    will return all records including "Coté".

    I suspect a problem with MUI (multi-user interface) but I did not find any
    recommandation at Microsoft.

    Thanks.
     
    Jacques Trépanier, Aug 29, 2007
    #1
    1. Advertisements

  2. This may have to do with the collation order of the new db.
    Check out CreateDatabase for more info

    Pieter

    "Jacques Trépanier" <> wrote in message
    news:...
    > Hi,
    >
    > We work in a mostly french environment. We have a standard image using MUI
    > Microsoft products (XP and Office 2003 are MUI) Since the convertion of an
    > ACCESS 97 BD into Access 2003, we experience a sort sequence problem when
    > using:
    >
    > DoCmd.Openform or DoCmd.ApplyFilter
    >
    > A selection on a name like "Coté" will return no record. Asking for
    > "Cote" will return all records including "Coté".
    >
    > I suspect a problem with MUI (multi-user interface) but I did not find any
    > recommandation at Microsoft.
    >
    > Thanks.
    >
    >
     
    Pieter Wijnen, Aug 30, 2007
    #2
    1. Advertisements

  3. Access 97 doesn't support Unicode but A2003 do; so it's possible that a
    conversion problem occured during the conversion. Are you sure that "Coté"
    has been really translated to "Coté" and not to something similar? What
    happens if you insert a new record or try with a brand new Access 2003
    database?

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: sylvain aei ca (fill the blanks, no spam please)


    "Pieter Wijnen"
    <>
    wrote in message news:...
    > This may have to do with the collation order of the new db.
    > Check out CreateDatabase for more info
    >
    > Pieter
    >
    > "Jacques Trépanier" <> wrote in message
    > news:...
    >> Hi,
    >>
    >> We work in a mostly french environment. We have a standard image using
    >> MUI Microsoft products (XP and Office 2003 are MUI) Since the convertion
    >> of an ACCESS 97 BD into Access 2003, we experience a sort sequence
    >> problem when using:
    >>
    >> DoCmd.Openform or DoCmd.ApplyFilter
    >>
    >> A selection on a name like "Coté" will return no record. Asking for
    >> "Cote" will return all records including "Coté".
    >>
    >> I suspect a problem with MUI (multi-user interface) but I did not find
    >> any recommandation at Microsoft.
    >>
    >> Thanks.
    >>
    >>

    >
    >
     
    Sylvain Lafontaine, Sep 1, 2007
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guest

    Problem with Access database conversion

    Guest, Sep 24, 2004, in forum: Microsoft Access
    Replies:
    2
    Views:
    246
    xionglina
    Sep 26, 2004
  2. Guest

    Access 97 to 2003 Database conversion.

    Guest, Mar 29, 2005, in forum: Microsoft Access
    Replies:
    1
    Views:
    317
    Douglas J. Steele
    Mar 29, 2005
  3. Guest

    Database conversion to Access 2000

    Guest, Oct 27, 2005, in forum: Microsoft Access
    Replies:
    2
    Views:
    261
    Tony Toews
    Oct 27, 2005
  4. Guest
    Replies:
    15
    Views:
    1,081
    John Vinson
    Jan 5, 2006
  5. Guest

    Conversion of 2.0 database to 2002? 2003?

    Guest, Jul 21, 2006, in forum: Microsoft Access
    Replies:
    3
    Views:
    272
    Allen Browne
    Jul 24, 2006
  6. Jennifer
    Replies:
    0
    Views:
    256
    Jennifer
    May 19, 2008
  7. eidinger2000
    Replies:
    0
    Views:
    736
    eidinger2000
    Feb 4, 2010
  8. M Shafaat
    Replies:
    5
    Views:
    1,176
    John W. Vinson
    Apr 10, 2010
Loading...