Incorrect collating sequence

[ferrisj]

I inherited some old Paradox tables (*.db) and when I try to import them into Access 2003 I am getting the error "Incorrect collating sequence". Has anyone ever heard of this and how did they correct it?

 

[IGPCS]

is this when you open a form or a table and from what format did you convert it from

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[lespaul]

When I googled your error message "Incorrect collating sequence", I found this page,

http://www.albionresearch.com/misc/obscurities.php,

which seems to indicate that since the source is Paradox, you need the Borland Database Engine (BDE) installed in order to get the correct information imported to Access.

Here's another link (

http://office.microsoft.com/en-us/access/HP010321651033.aspx)

about the paradox driver, have you installed that?



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi