D
djf
I'm in the process of converting from Access 2003 to Access 2007. When I
converted my 2003 db to 2007 the VBA code would not run. I changed the
Reference libraries in 2007 to match what I had in 2003 and then the code
worked. I'm looking for some clarification on what the difference is between
my 2003 set up and the default set up for 2007. What is the difference in the
libraries?
All of the references were the same in 2003 and 2007 except for the following.
2003
Microsoft DAO 3.6 Object Library
2007
Microsoft Office 12.0 Access database engine Object Library
Microsoft Visual Basic for Applications Extensibility 5.3
I deleted the two references for 2007 shown above and put in the DAO 3.6 in
their place and the code works.
converted my 2003 db to 2007 the VBA code would not run. I changed the
Reference libraries in 2007 to match what I had in 2003 and then the code
worked. I'm looking for some clarification on what the difference is between
my 2003 set up and the default set up for 2007. What is the difference in the
libraries?
All of the references were the same in 2003 and 2007 except for the following.
2003
Microsoft DAO 3.6 Object Library
2007
Microsoft Office 12.0 Access database engine Object Library
Microsoft Visual Basic for Applications Extensibility 5.3
I deleted the two references for 2007 shown above and put in the DAO 3.6 in
their place and the code works.