Yearly Archives: 2011

Thinking about hosting your SQL Server database on the web?

Hosting on the web is a hit or miss, you will find a wide range of providers, from dirt cheap hosting companies that will lump you in with hundreds of other databases, to premier firms that will rent you a server all for your self. Many traps to avoid If you're not careful you may end up with a host [...]

2015-07-03T19:30:03-05:00December 27th, 2011|

Our favorite online small business tools

Our Access/SQL Server/SharePoint practice benefits from great tools on the web, some free and some not, and I'd like to share our experiences with you. (Free) and LogMeIn Ignition (Subscription) for Windows We usually use the Remote Desktop Connection when working with our client's syste [...]

2011-12-21T05:01:23-06:00December 21st, 2011|

New book for Access Web Database and SharePoint now available!

As Juan may have mentioned earlier, I had been working with two other MVPs, Tim Runcie and George Hepworth in producing the first of its kind, a book dedicated to using Access with SharePoint. The book can be bought online at the Advsicon store. If you're wanting to learn more about the capabilities [...]

2022-08-02T10:24:32-05:00December 17th, 2011|

How to work offline with SharePoint and Access 2010

One advantage a SharePoint list has over any ODBC data source is that Access can disconnect and re-connect and synchronize the local edits back to the server fairly seamlessly. It also provides a friendly conflict resolution management, all out of the box. This is available whether you're using a tr [...]

2016-03-08T01:13:58-06:00December 8th, 2011|

Microsoft's Official Response to ADO mess…

Those of you caught with the Windows 7 SP1 bug that rendered your development computer useless for Access 2007, (including yours truly), can read up on the official Microsoft response to the issue here: [...]

2011-12-05T23:10:50-06:00December 5th, 2011|

Using control tip property to display real time information

I was selected to be a guest blogger on the official Microsoft Access blog! You can read the article here: Please read and come back here for some final thoughts on the techn [...]

2011-11-29T05:31:22-06:00November 29th, 2011|

Running Access locally on a different domain using VPN

We develop solutions using Access on the desktop and SQL Server on the network for clients throughout the US. Our standard method is to log in to the client's network via VPN and program on their server since we couldn't program on our development machines using the credentials provided by our clien [...]

2021-03-03T15:21:09-06:00November 22nd, 2011|

Query Pattern: Finding the maximum/minimum and getting the full row

Authored by Ben Clothier The other day Juan needed my help with a query that required a special technique commonly known as the Strawberry query. He needed a way to match one group of records with the first occurrence of a item in another table. From that I decided to write this post to share the te [...]

2023-07-07T05:47:56-05:00November 17th, 2011|

More fun with Inner Joins

A while back I wrote about a Inner Join technique using a date range. (You can find that post here.) Today I'm going to take it a step further and discuss using inner joins to another query and conclude with an issue in Access you may shed some light on. Using Queries as Inner Joins For the longes [...]

2021-12-14T09:44:37-06:00November 14th, 2011|

Windows 7 64bit Slow with Access 2007 – Solved!

A while back I talked about a problem one of my clients was having with Windows 7 64 bit and Access 2010/2007. It was terribly slow and unacceptable. You can see the original post here. Solution Found - Turn off the LLMNR Protocol My client waited long and hard to get this resolved, but Microsoft di [...]

2017-02-06T22:01:01-06:00November 2nd, 2011|

More Alter Table SQL Statement Help

Creating a primary key using that is also a auto increment field in code can be challenging. This article will discuss how to do so in two steps.

2011-10-31T09:36:48-05:00October 31st, 2011|
Go to Top