Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Microsoft ISV Community Center Forums >> Visual Basic for Applications (VBA)

Replacement for VBA

I know Access 2007 will continu to support VBA, but for new applications I would like to use a .NET based solution. VSTA and VSTO come to mind, but VSTA is currently only available in Infopath 2007 beta, and VSTO v3 only gives you the ability to create application-level add-ins for Access.
Will VSTA or VSTO document-level integration be available for Access 2007, and which one would be the best replacement for VBA in Acces-applications?
[445 byte] By [willemvangennip] at [2007-12-22]
«« Write Cashing
»» Using parameters with ReportBuilder
# 1
Hi Willem
<<I know Access 2007 will continu to support VBA, but for new
applications I would like to use a .NET based solution. VSTA and VSTO
come to mind, but VSTA is currently only available in Infopath 2007
beta, and VSTO v3 only gives you the ability to create application-level
add-ins for Access.
Will VSTA or VSTO document-level integration be available for Access
2007, and which one would be the best replacement for VBA in
Acces-applications?>>

None of the above. If you want to go to a .NET solution, I outlined the
options open to you in my reply today, in a newsgroup.
It actually doesn't make any sense to use VSTO because, for a database
application, it should be simple enough to create a WinForm application
front-end to the database, using ADO.NET. Unlike other Office
applications, you don't need to be in the application to allow users to
work with the data. If you want .NET support, then you supposedly want
to use the capabilities the .NET Framework provides: securty, WinForms
controls, etc.
-- Cindy Meister

CindyMeister at 2007-8-30 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...
Microsoft ISV Community Center Forums
Visual Basic for Applications (VBA)

Microsoft ISV Community Center Forums Hot Topic

Microsoft ISV Community Center Forums New Topic

Microsoft ISV Community Center Forums

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified