ADP Crashes on table sort

[Simon]

I am connecting to SQL Server 2000 (sp3a) through Access 2002 projects, but
I am finding that trying to sort fields in any table through the datasheet
view in any project is crashing Access.

The error is either in msaccess.exe modname oledb32.dll.

This is happening with ADO library versions 2.0, 2.1, 2.6, 2.7 & 2.8.

Linking tables via ODBC in an MDB & then sorting works OK.

I am running Windows 2000 with MDAC 2.8 & Office XP Service Pack 3
installed.

Can anyone please help?

 

[Mary Chipman]

Use an ORDER BY clause in the underlying query when you want to sort.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

 

[Simon]

Is this indicative of some other problem? This happens if there are only two
records in table. I have yet to have it happen elsewhere.

 

[Mary Chipman]

I don't know. I never use datasheet view for anything. It used to be
really really flaky, so I stopped around v2. I guess it still is
flaky.

-- Mary
MCW Technologies
http://www.mcwtech.com