You know DAO has been deprecated for quite some time now, right? It also won't work on 64-bit Windows.
I
highly suggest abandoning DAO and switching to OLE DB for using Access databases.
Do you have any particular reason for using Access and not going direct to the SQL Server using ? Removing Access would eliminate a level of complexity and improve performance.
Data Access Technologies Roadmap[
^] circa December 2009