You need to change the DAO reference to a different
version. Press Alt-F11 to show the code. Then go to tools-
references and select Microsoft DAO 3.6. If that is
checked and it is still not working, that means there is
something else checked that is interfering with the DAO
3.6 Try unchecking other things that aren't needed.