I am a hobbyist programmer and my vba programs were written on access 2003 recently I upgraded to 2010. All of my old mdbs and vba programs run and when I look at my library reference I have both the 14.0 object library and the DAO 3.6 object library checked.
I wanted to share one of my programs with a friend on 2007 but when his reference shows the 12.0 object library and it will not let him reference the DAO 3.6 library. Try as I might I cannot figure how to get the programs to run for him. It will not recognize the dim db and dim rs statements.
The problems are with dim db as database and dim rs as record set.
Is there a library that supports these statements like DAO does?
Thanks