Access 2000, Dao 3.6 & dbgrid bug 
Author Message
 Access 2000, Dao 3.6 & dbgrid bug

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.



Tue, 12 Nov 2002 03:00:00 GMT
 Access 2000, Dao 3.6 & dbgrid bug

Mary,

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

Quote:

> 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.deja.com/
> Before you buy.



Tue, 12 Nov 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. DbGrid and DAO 3.6 and Data Base Access 2000

2. Can I use DbGrid, Dao 3.6 and Access 2000

3. DAO 3.6 and Windows 2000 Bug.

4. display chinese using DAO 3.6/VB6 in accessing Access 2000 DB.

5. DAO 3.6 fails to compact Access 2000 databases

6. Access 2000 with DAO 3.6

7. VB6 DAO 3.6 Copy data from Foxpro 2.6 to Access 2000

8. DAO 3.6 with Access Database 2000 with relationships defined

9. DAO 3.6/ACCESS 2000/Edit und Locking

10. DAO 3.6 and Access 2000

11. Access 2000 and DAO 3.6 Problem

12. Deployment of DAO 3.6 on 2000 / XP Help requested


 
Powered by phpBB® Forum Software