Data-Control and Access 2000

[StephaneG]

Hello,

I have an application that was created with VB5, and using an Access-97 database. The database was recently converted to Access-2000. I have made the necessary modifications to use DAO 3.6 as indicated on the Microsoft Knowledge Base (http://support.microsoft.com/support/kb/articles/q238/4/01.asp) but the Data-Control doesn't seem to recognize the database format. I am using a DBGrid and the program crashes whenever I try to do a Data1.Refresh, or if I specify a Datasource in the control's properties... Anything I can do? Would this problem be resolved if I upgraded to VB6?

Thanks,
Stephane Gaudreau.

I have this problem since April 1999 (I've got Office 2000 as MSDN subscriber). Although Data control theoretically can work with Access 2000 (create DAO recordset and assign it to Data control Recordset property at runtime) it gives run time errors very often after making EXE. No problem before EXE. So I decided to use old (97) format. Why do I use DC? I have several Sheridan controls which do not work with DAO recordsets (only with DC). ADO is slow with Access. Project is too big and complicated to be rewritten without Sheridans. If you do not have any special requirement to use DC, don't use it.
HTH
Vlad