The company I work for has just upgraded to Access 2000, and I've been having 'fun' <img src=/S/headthrob.gif border=0 alt=headthrob width=15 height=15> getting the Access 97 databases to work smoothly, still it's been a learning experience <img src=/S/crybaby.gif border=0 alt=crybaby width=15 height=15> .
The latest 'lesson' is that someone has to physically select the DAO 3.6 check box in the reference dialogue box before any VBA with a DAO.Database or DAO.RecordSet will run. My question is this, do I have to walk round every PC that will use my databases and check this box, or is there a way round this? Like making my databases into .MDE files?
This may sound like laziness, but as Access is installed on a 'needs it' basis there could be problems in future when a new user hasn't got the DAO library sorted out and I'm trying to avoid this situation.