Free SQL Server books from Microsoft
Here's a great way to learn more about SQL Server, Azure, Windows Server and other Microsoft technologies with this collection of Free ebooks: UPDATE: Here's a more recent list of free books from Mic [...]
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, [...]
Migrating Access backend to SQL Server in the cloud
What does "moving Access application to the cloud" mean? It means you are moving your data to a hosted SQL Server database on the web. You no longer have the data locally and you are still running the [...]
10 things every Access developer who works with SQL Server should know
Working with SQL Server and Access can be challenging, here are 10 things you should know about SQL Server and Access: Using a pure Access solution, (no SQL Server), is almost impossible over VPN, but [...]
Why the Project Kickoff Meeting is your most important step
As Access Developers we deal with projects, both small and large, that may span hours or months. Our time is valuable, so it's important we are effective from start to finish with our client's project [...]
¿Que debería usar y cuando, DAO o ADODB ?
En mi grupo de Access con SQL Server en LinkedIn, uno de nuestros miembros publico la siguiente pregunta: ¿Si estoy desarrollando un proyecto nuevo, qué debería usar: ADO o DAO? Vamos a desglosar el t [...]
Why you should always use a recordset when executing stored procedures
I've talked about using a recordset with stored procedures before, but this time I wanted to emphasize the importance of always using a recordset when executing a stored procedure from Accerss VBA. Co [...]
I’ve started a new LinkedIn group: «MS Access with SQL Server»
For some time now I've been posting articles on LinkedIn MS Access groups. The posts vary the gamut, from Access topics to management posts. I've enjoyed the discussion and feedback on the boards, and [...]
A new domain, a new look, same great content
Today we launched a new domain and look for our site! We have moved all of our content over to AccessExperts.com and have redirected all content from our old site to our new one. The new design offers [...]
Enviando reportes desde Access como PDF adjuntos en Outlook.
Me encanta integrar Access con Outlook, es muy sencillo crear un sistema que permite a nuestros clientes enviar reportes como documentos adjuntos en un correo electrónico. Objetivo: Enviar una factur [...]
