Incorrect Collating Sequence

[stattad]

I tried this question a few weeks ago, but I'm trying again.

I have 2 Access 2002 files. One has a sort order of ascii and one has a sort order of international. I need them to both have the same sort order. It doesn't matter which one. Right now I get the above error message on one of them.

How can I change the sort order so that I can import Paradox files like I used to?

 

[neileg]

When you use the term files, I presume you mean tables. A table is basically an unordered dataset. Why don't you use queries based on the tables to impose the order you require? This way it doesn't matter how the data is held in the table.

 

[Pat Hartman]

How can I change the sort order so that I can import Paradox files like I used to?

this should be an option under Tools/Options. You can also specify database order in modules so look at the first couple of lines of each code module to see if an order is specified there.

 

[stattad]

Yes, I meant tables. There is no choice for ascii or international under Tools Options that I can see. As far as looking at the "module", I'm not sure how to do that.

I just want these tables working the way they have for the past 3 years.

 

[Pat Hartman]

Tools/Options - General tab - new database sort order.

 

[stattad]

I don't know what version you're using, but mine has nothing but foreign languages and "general", which is what it says now.

 

[Pat Hartman]

I'm using 2003 and I have a long list.

How did you determine the sort order was international or ASCII?

 

[stattad]

You just gave me a clue. Another user gave me information about changing the sort order in regedit. He was sure the problem was the way Access looks for the file. But the place where I have to keep switching it back and forth from ascii to international is under
HKEY_LOCAL_MACHINE
Software
Microsoft
Jet
4.0
Engines
Paradox
Collating Sequence

The fact that it's under PARADOX sounds like the problem should be fixed there, but these are the same files I've used for over 10 years (before I got Access). I don't believe there's any place to fix the sort order (or collating sequence).

 

[Pat Hartman]

Where do the Paradox files come from? Is the sort order being changed at the source?

 

[stattad]

Believe it or not, I believe I created them in 1990. They are an NFL file and a coll. FB file. Every year I empty them and start entering data from the first game of the season. I have looked through my Paradox manuals and see nothing about "incorrect collating sequence". I don't have any sort orders set up.

 

[Pat Hartman]

Perhaps it's time to give the paradox application a decent burial and move to Access for the data entry also.

 

[stattad]

I will never give up on Paradox, because it does 42 queries in about a second and spits the information out in a report in the same amount of time. I just haven't found Access to be user-friendly in that area.

I will have to give up on trying to find a solution. It must have something to do with going to a new computer and XP last December, but the files worked fine for the couple of weeks last year before the season ended.