DLL Confusion

[frankvfox]

What DLL version do I need to add to a Visual Studio 2010 project in order to automate Access 2003? I've imported Microsoft.Office.Interop.Access


(Microsoft Access 11.0 Object Library) version 9.0.0.0 and Visual Studio doesn't recognize it. Windows Server 2008 R2 Enterprise 64 bit.

Thanks.

Frank Fox
Hendersonville, TN

[June7]

What do you want to do - get data from Access into Visual Studio? http://msdn.microsoft.com/en-us/library/ms171893.aspx

[frankvfox]

What do you want to do - get data from Access into Visual Studio? http://msdn.microsoft.com/en-us/library/ms171893.aspx

I want to run Access Reports from my VB project. (Using the DoCmd functionality). My problem is the Access Reference (Microsoft Access 11.0 Object Library) I've linked to is not recognized by VB. I should mention it's been several years ago since I did this last. I believe I'm running Framework 4.5.1.

Has something changed in the interim?

Frank Fox

[June7]

Try:
Microsoft ActiveX Data Objects 2.8 Library

http://support.microsoft.com/kb/317113

http://www.codeproject.com/Articles/...-Reporting-Way

[frankvfox]

Is there anybody out there who understands what I'm asking? Why can't VS 2010, after acknowledging the presence of the Access Reference (Microsoft Access 11.0 Object Library) in the solution explorer, allow me to instantiate an Access.Application object with a simple "acc = New Access.Application"!!?? Instead, it puts the squiggly line under "access.application" and proclaims "type access.application is not defined"! Is there a problem with Windows 2008 Server R2?

[June7]

Sounds like the issue is on Visual Studio side. Might try a forum that focuses on VS.

[frankvfox]

Sounds like the issue is on Visual Studio side. Might try a forum that focuses on VS.

Thank you. I'll redirect.