Hi, How Can We Help You?

Six Hat News

img Sticky Post

The long overdue article: Source Control with TFS and Microsoft Access 2010

So if you are interested in adding source control to Microsoft Access 2007 or 2010 then read on as I will step you through the process… or for those of you who would rather watch a video you have that option as well by following this link: https://youtu.be/vPmwPHYVd-Q You should also note that you have the ability to add source control for 2007 and 2010 with VSS as well. Microsoft dropped VSS years ago. So to integrate VSS with Access you would have to acquire a very ancient (in technology years) VSS 2005, which is still available through your MSDN subscription. You will find the steps between VSS...

Read More
img Sticky Post

Don’t Bring Microsoft Access to the Web, Bring the Web to Access

It’s the day and age where everything is internet related. For years Access developers have wanted a way to bring an Access database to the web… and well, Microsoft has responded with some components that have given you some functionality… but in my opinion does not truly deliver what is really desired. To date when a client asks for a fully functional Access database on the web my default is a Terminal Services solution (Which Server 2012 has Renamed Remote Desktop Services) usually hosted in a Microsoft Azure Virtual Machine environment. As hot a topic as Access applications on the web is...

Read More
img Sticky Post

Email From Microsoft Access The Easy Way

I just wanted to share a great solution I’ve recently developed in Emailing from Microsoft Access. Of course there are 100 ways to send an email… but the usual suspects when it comes to emailing from Microsoft Access are usually Docmd.SendObject (which is very simple but has the limitation of a single attachment), CDO (which is also fairly easy and allows for multiple attachments), and my least favorite method of all… emailing from Microsoft Outlook (also allows for multiple attachments and other features… but can be a headache to deal with because of inherent security...

Read More