Tag Archives: Access and SQL Server

Microsoft Access Client With SQL RemoteApps and SQL Azure Might Just Be What The World Is Looking For About Now

Posted on April 1, 2015 by Biggus Dickus

OK … Here we go… Enough time has elapsed since the teaser about “Access Forever” … Today I am going to build a case for using Access Client Software forever (or effectively forever) in the Cloud and on any device. … Continue reading →

Posted in Uncategorized | Tagged Access, Access 2010, Access 2013, Access and SQL Server, Access Developer, Access Services, Azure, Azure RemoteApps, Information Consultant, RemoteApps, SQL Azure, Windows 10 | 34 Comments

PowerPivot CTP3 Hierarchies Make All The Difference

Posted on September 26, 2011 by Biggus Dickus

I have been around OLAP databases since 1994. By “around” I mean that I have used them off and on for all those years without actually becoming a true BI dev – rather I am an occasional consumer. This is … Continue reading →

Posted in Uncategorized | Tagged Access 2010, Access and SQL Server, Cubes, Excel, Excel 2010, Hierarchies, Information Worker, Microsoft Access 2010, Microsoft Excel, Microsoft Excel 2010, Office 2010, Office Development, OLAP, PowerPivot, SQL Server | 3 Comments

The Perfect Storm

Posted on April 27, 2011 by Biggus Dickus

For years I have been arguing that the combination of Excel and Access is the strongest “story” in Microsoft Office – and the most ignored. I have used these two products together and separately to deliver solution after solution that … Continue reading →

Posted in Uncategorized | Tagged Access, Access 2010, Access and SQL Server, Access Services, Excel, Excel 2010, Information Worker, Microsoft Access, Microsoft Access 2010, Microsoft Excel, Microsoft Excel 2010, Office 2010, Office Development, SharePoint, SharePoint 2010 | 4 Comments

Access Hosting Now Makes Sense

Posted on April 19, 2010 by Biggus Dickus

One of the things I have always thought would help me expand my business was the idea of Hosting apps on a server of my own. I think that Access 2010 with Access Services will open up this as a … Continue reading →

Posted in Uncategorized | Tagged Access, Access 2010, Access and SQL Server, Access Services, Microsoft Access, Microsoft Access 2010, Office 2010, Office Development, SharePoint, SharePoint 2010 | Leave a comment

Access 2010 And SharePoint – Welcome To The Hybrid Access Application

Posted on November 6, 2009 by Biggus Dickus

Now that we can talk about all the features in Access 2010 I think I have to place my marker immediately on what I believe is the BIG story in this release. For the past 3 or so years I … Continue reading →

Posted in Uncategorized | Tagged Access, Access 2010, Access and SQL Server, Office 2010, Office Development, SharePoint, SharePoint Lists | 126 Comments

Access vs Web

Posted on August 30, 2009 by Biggus Dickus

A friend was over for dinner last night who is an IT manager and former client of mine. I have done several hugely succesful major Access/SQL Server applications for this guy when he was with another corporation. We went into my office and … Continue reading →

Posted in Uncategorized | Tagged Access, Access and SQL Server, Office Development, SharePoint | 9 Comments

Thoughts On Access and SQL Server

Posted on July 3, 2009 by Biggus Dickus

I am working on some stuff today using SharePoint Lists with an Access Frontend. Frankly the reason I am using SP Lists is because this particular client’s IT department won’t allow Access going against SQL Server (a common problem). SP … Continue reading →

Posted in Uncategorized | Tagged Access, Access and SQL Server, SQL Server | Leave a comment