This week I'm at Paug's Access conference in gorgeous Silverfalls, Oregon. I'll be live blogging here so come back here often for frequent updates over the weekend. It's sold out - again Yet again this year's conference was sold out, not because there's a ton of people here but there is a low thresh [...]
Today's guest post come's from Mark Davis, a Access MVP. You can learn more about him at http://www.linkedin.com/in/markgerarddavis At its simplest definition, recursion is a function that is applied to itself, or a function that is called by itself. Here is a basic example, taken from mathematics, [...]
Author note: This is the final post on a four post series on DSN-less tables in Access. You can review part one here. Take a look at part 2 here. See part 3 here. How can you test changes in the cloud with your Beta users? Once you've rolled out your Access masterpiece using SQL Server in the cloud, [...]
Author note: This is part 3 of a series on DSN-less tables in Access. You can review part one here. Part 2 here. Part 4 here. In part three of this series I'm going to give you the code to delete all of your linked tables once the app closes. Deleting your links makes your app secure since both the [...]
Author note: This is part 2 of a series on DSN-less tables in Access. You can review part one here. Part three here. Part four here. In last week's post I talked about using a single table in your SQL Server database to easily manage security, in today's post I'm going to take it one step further an [...]
Author note: This is part 1 of a series on DSN-less tables in Access. You can review part two here. Take a look at part three here and part four here. In my first post on this topic, I sent you to Doug Steele's great article on how to do DSN-less table connections. Today I'm starting a new series of [...]
Many of you know that I'm a big fan of Access with SQL Server, and if you're a frequent blog reader you will also know it's not easy to optimize the relationship between them, it takes work but it's very rewarding when they're working great. Some developers however go to the extreme and use unbound [...]
In one of our client's applications, we built an email template that sometimes may attach files to be sent out. Our client wanted a way to preview the attachment before they actually send the email. This created a dilemma - if they can preview and potentially edit the files, we certainly don't want [...]
Office.com has again asked me to write a guest post for them, click below to see the post: Five Common Pitfalls When Upgrading Access to SQL Server They were also kind enough to interview me: Q&A with Access developer Juan Soto Join me at the PAUG conference! I'm really pumped abou [...]
Ben has completed the first phase of a two phase project using Access 2010, SQL Server in the cloud and FileStream; all coming together in one nice solution we would like to share with you. Creating proposals using Access and Word We were hired by an insurance company to create a solution that would [...]
Click image to learn more about the book On occasions, we have a need to zip files as part of our workflow within Access VBA. One sore point with zipping is that there's really no simple way to zip or unzip files without depending on a third-party utilities. When you think about it, it is quite od [...]