Is anybody having a problem with DAO 3.6 and the
dbgrid data access error messages? I am working
on upgrading a VB6 project using Access 97 to
Access 2000.

I already changed from using the data control
reocordsource property to using the recordset
property as described in the Microsoft workaround
for the "Unrecognized database format" error
message, but another problem has come up.

Upon adding or changing a record in the dbgrid
linked to the data control, all data access
errors are coming back "Item not found in this
collection" instead of the correct error message.

                       Any clues?
                       Thanks,
                          Mary

Sent via Deja.com http://www.***.com/
Before you buy.

I'm not sure, but here's a guess: the DAO recordset 'name' property is
limited to 256 characters (see MSDN Article ID Q168194).

Is your SQL longer than 256 characters.  If so, it may be getting truncated
and hence not being properly 'understood', giving you the 'item not found'.

check your SQL by displaying it in a Msgbox temporarily and see if it is
what you expect.

Again, I'm not sure, but we ran into this problem.

+Rich