DAO's causing me troubles!!!!

Hi friends,

I had been using the access 97 till last year. Now I am using the access 2000. Whenever I try to use the dao's with the database, it gives me an error that unrecognized format. It has no problems with the 97 version. What should I do to rectify my errors.

[parksie]

Make sure that you are using DAO version 3.6 (check under the References dialogue).

[Clunietp]

http://support.microsoft.com/support/kb/articles/q238/4/01.asp?LNG=ENG&SA=ALLKB

[eanilarora]

Check out your DAO Version
It should be 3.6 or more
to be able to connect to Access 2000 database
3.5 works only with Access97

Moreover it is high time you moved
to ADO's

Happy Learning

[parksie]

Actually, ADO is slower for Access than DAO. If you only plan on using Jet, then it's best to stay with DAO as it has native support for all the features. ADO is more general.

[Clunietp]

ADO is slower than DAO for MS Access databases, but DAO is being phased out. Therefore, all new development should be done using ADO

In a few years, maintaining a DAO application would be like trying to maintain a DBLib or VBSQL application today (not that I've ever maintained one of those, but you catch my drift....)

[JHausmann]

Nope, no formal date for obsoleting DAO. I'd expect RDO to go first :)