Somos Expertos Access. Contacto atravez de Skype Skype logo expertos_7

What I’d love to see in the next version of Access

It’s that time of the year again folks, where the Access team is debating what to include, fix or remove from the next version of Microsoft Access, and if past history is any notion of what to expect, don’t expect anything to change on the client side: no new IDE tools, no new coding tricks, nada. *SIGH*

It’s all web and nothing else going forward

Let’s face it, the web mantra is dominating Access future and it isn’t going to change. To that end, here are my top requests for the next version of Access:

  • Allow the web version to invoke TSQL scripts: I understand you, (meaning Microsoft), want us to use macros, I get it. But macros will only take us so far as developers, WE NEED MORE. Let us tap into the power of SQL Server and add a simple Exec command to the macro language that will allow us to invoke any script on the SQL Server side. We would of course want the ability to write any arguments and reference elements on the form as part of using the Exec command.
  • Let us tap into the awesome power of Reporting Services: (Are you seeing a trend here of including more SQL Server integration?) Allow us as developers to invoke the reports by again using custom arguments or elements from the form. For example, if the form is displaying an order and we want to display the order report, we would like to reference the OrderID field on the form when the report is launched. For example: RunSSR(“rptOrder”, Me.OrderID). Don’t get me wrong, Access has great reporting capabilities but it’s not SQL Server Reporting Services. If the data is now being stored on SQL Server than why NOT use it?
  • Allow us to use integrate with SharePoint lists, documents, sites etc. The Access web apps are stored in SharePoint, why not allow more integration with SharePoint’s features and/or data?

What are some of your new feature requests in the next version of Access?

 

Update: Access 2013 web apps now support linking to any SharePoint lists from any SharePoint site, albeit read-only. You can use a web browser control to point to a page for editing SharePoint lists within the Access 2013 web app and still have capabilities to perform queries against the SharePoint lists. This is actually a big improvement over 2010 web database where you could only have SharePoint lists on the same site where the web database was published to, and could not use Document Library.

Acerca de

Juan Soto es un desarrollador senior de Access en IT Impact Inc. y un MVP de Microsoft Access y se especializa en Access con bases de datos de SQL Server. Su pasión por el acceso lo ha llevado ayudar a una amplia gama de empresas a establecer un entorno seguro, estable y eficiente con SQL Server. Él es un orador frecuente en los grupos de usuarios de Access en todo el país y recientemente habló en el Orange County SQL Saturday # 73. Si desea que Juan hable en su próxima reunión de grupo, puede ponerse en contacto con él aquí.

Publicado en Uncategorized

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

*

 

Quienes Somos

ExpertosMicrosoftAccess.com es un servicio de la empresa IT Impact, Inc., una compañía de programación y servicios para empresas en Latino América. Ofrecemos servicios en .Net, SQL Server y Microsoft Access. Muchos de nuestros desarrolladores han obtenido el galardón de Access MVP, un título proveído por Microsoft a aquellos que han hecho aportes a la comunidad y que han demostrado tener conocimientos superiores del producto.

Nuestro Equipo

  • Le ayudamos a "Descubrir el poder de sus datos™" con reportes y sistemas de Access excepcionales .
  • Creamos soluciones de bases de datos personalizadas utilizando Microsoft Access y / o SQL Server.
  • Nuestros consultores ganaron sus estrellas en las empresas de servicios y/o manufactura antes de convertirse en programadores.

Blogs anteriores