We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Sort Order in Access seems different than DOS ASCII

Medium Priority
258 Views
Last Modified: 2013-11-29
I have converted data from DOS FoxPro to Access 2002

We have a field in the DOS that I also use in the Access 2002. The field is a sort field, but it looks like the information is not sort as it did in DOS.

What it was: the dash is the one in question.
PROFFITTRAY
PROFFITTRAY-
PROFFITTRAY&
PROFFITTRAY-JONES
PROFFITTRAY&JONES
Now it is: the dash with a name after is not sorting the same as it did in DOS above
PROFFITTRAY
PROFFITTRAY-
PROFFITTRAY&
PROFFITTRAY&JONES
PROFFITTRAY-JONES

Comment
Watch Question

Hi, this is a by design feature of JET v4.0. Please see http://support.microsoft.com/kb/236952/en-us
Cheers, Andrew

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks Andrew.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.