Hi, Brad

I been use ODBC/32 and MS Access. It works great, most my form
is Main form(Master) and Link with subform(Detail Set) by Key Items.
Subform Links to another subform(Another Detail Set) by key view as
datasheet view.

For Example Customer with Combo search key will display Invoice
Header (data sheet View) and move cursor to that Invoice number
to display Invoice detail in one form, It works great...

Right Tool for Right Job, We are not software QA for vendor, 
unless they paid for us.

Cheers
Peter C.
>>> Brad Feazell <[log in to unmask]> 10/26 7:44 AM >>>
I think I've found an incompatibility between ODBCLink/SE-32 and MS Access
2000. In a very simple case, I tried to use a DSN to a database that is
already setup and working fine for Access 97. When I link a table and try to
open it, Access says:

"Microsoft Access can't open the table in datasheet view"

I can't use a select query to find a single record or use a form to access
the records either. I can however open the table in design view and see all
the fields. Curiously enough, Excel 2000 works fine against the same DSN.

Has anyone else run into this and found a workaround? I wrestled with HP for
an hour yesterday and they don't seem to know (or care) about the problem.
I've reproduced this behaviour on Win95, Win98 and NT 4.0 machines so I know
it's not just my machine.

--
Brad Feazell

SR. ERP/MRP Analyst