I've inherited a project which pulls data from 2 DB (*.mdb), one is access 97 and one is access 2002. DAO 3.6 is referenced. We use OpenDatabase and OpenRecordset instructions. When running, we get "Unrecognized data format" error or error code 3343 when attempting to refresh any table in the access 2002 DB.
Any clues??
Giffordw
0
Newbie Poster
Recommended Answers
Jump to PostSwitch over to ado or save the 2k2 database in a previous format 2k or 97...
Good Luck
Jump to PostI wonder why people use DAO instead of ADO. I find ADO connection is best to use rather than DAO. If you have some knowledge about ADO connection, you can switch between any number of DB. I prefer ADO instead of DAO.
Thanks
All 6 Replies
vb5prgrmr
143
Posting Virtuoso
kinwang2009
7
Posting Whiz in Training
vb5prgrmr
143
Posting Virtuoso
Giffordw
0
Newbie Poster
hkdani
39
Posting Pro in Training
Giffordw
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.