[AccessD] (OT) VB Express + SQL Server Express ??

MartyConnelly martyconnelly at shaw.ca
Sat Feb 11 15:00:47 CST 2006


Why not just call Access Reports from VB.Net
You will need either the Microsoft Office XP or 2003 Primary Interop 
Assemblies (PIAs).
Microsoft Office XP primary interop assemblies (PIAs) are available for 
download
XP
http://support.microsoft.com/kb/328912/EN-US/
2003
http://support.microsoft.com/kb/897646/
Then
How To Automate Microsoft Access From Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;317113

or more general

http://support.microsoft.com/kb/311452/
http://msdn.microsoft.com/office/default.aspx?pull=/library/en-us/odc_of2003_bk/html/officeinteroperabilitych2_part1.asp

 you may have to reference the Microsoft.Office.Interop.Excel namespace 
through an alias, like so:

using Excel = Microsoft.Office.Interop.Excel;
simple access vb.net access program
 Developing Office 2003 solutions with .NET
http://builder.com.com/5100-6373_14-5315974.html#Listing%20A
 



Dan Waters wrote:

>I've downloaded VB Express to get a look at the features.  I've never
>developed with VB before (just Access), and I remember reading that
>subforms/subreports aren't available in VB.  I looked through the list of
>controls for forms, and didn't find any reference to subforms/subreports.  
>
>Also, VB doesn't have a reporting feature like Access.  SS 2005 has
>Reporting Services, but SS Express doesn't. 
>
>So, is the idea of using VB Express with SQL Server Express for business
>applications not feasible?  
>
>Does anyone have experience using these products yet?
>
>Dan 
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list