Question posted 2013 · +4 upvotes
I created a new Console project in VS2012.3 (32bit exe) and added a COM Type Library reference to Microsoft Access (I tried both 2003 and 2007). The “Microsoft Access” reference shows up in the Add Reference dialog no problem. However, upon closing that dialog VS displays a yellow triangle overlay on the two newly added references, and I get the following build error:
Could not resolve COM reference “4affc9a0-5f99-101b-af4e-00aa003f0f07” version 9.0. Object reference not set to an instance of an object.
My colleagues are able to do this with no problem on their computer. So I’m trying to figure out what could be the problem with my machine. I’m running Windows 8.1, whereas others are running a mix of Windows 8.0 and 7. Any ideas?
Update – Some screen shots:
Accepted answer +7 upvotes
Problem Solved:
I found the solution here: http://support.microsoft.com/kb/823996.
All I had to do was open the “Developer Command Prompt for VS2012”, navigate down to the GAC’s ADODB folder, then run regasm.exe ADODB.dll. That fixed the entire problem.
Problem solved:
Top ms-access Q&A (6)
- How can I modify a saved Microsoft Access 2007 or 2010 Import Specification? +31 (2008)
- OleDbCommand parameters order and priority +28 (2009)
- Is there an equivalent to the SUBSTRING function in MS Access SQL? +26 (2009)
- What do I need to read Microsoft Access databases using Python? +25 (2009)
- MS Access library for python +24 (2009)
- is there any replacement of Access? +21 (2009)
ms-access solutions on this site
.