Recording of Access Kung-FU now available
If you did not make it to our live session you can do the next best thing, see the recording below: [vimeo]https://vimeo.com/45720384[/vimeo] If you attended the session please leave a comment below. [...]
Reminder: Tomorrow morning at 8 AM CST Access Kung-Fu!
Come join us tomorrow morning at 8 AM Central Daylight Savings Time, (GMT-5), for a great session on high level Access topics! To join, just go to www.join.me/accessexperts. You will need to either use the computer speakers and type your question or click on the phone icon at the top of the toolbar. [...]
Live on July 13th, Access Kung-FU, mastering Access session
My Access Kung-Fu is strong, join me on July 13th as I demo advanced topics I previously held this session at night, but that made it almost impossible for Europe or Asia to participate. Now you can join me this Friday at 8 AM for a two hour world wide session. Here is what you will learn: Master th [...]
Microsoft Surface: Get ready for Access on a tablet
Microsoft last Monday held a press conference to demo a new tablet called Surface, you can catch the 90 second summary here. One Killer Feature missing on Tablets: Corporate Databases There is no way to enter, store and upload data to corporate databases using existing tablet technologies without us [...]
Securing your ADO connections
A while ago, I wrote about securing the ODBC connections which was published on Access team's blog. Also, Juan recently wrote about the alternate method of deleting/recreating linked tables in a four part article. But what about ADO connections? A typical approach for creating an ADO connection may [...]
If your client sees you as a cost center you already lost…
Access can do great things, on a short time frame and with a smaller budget than other technologies. If your client can't see the benefits of your work it's your responsibility to step up and show them how your work output should be considered as part of a profit center. Here's how: -- Perform a pay [...]
Subquery and the Scalar Query
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 The concept of a subquery itself is fairly straightforward: have a query within a query. However, there are various applications of the subquery. Most frequently, a sub [...]
PAUG Live Blogging
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 [...]
Using Recursion in your Access database
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, [...]
Part 4: Switching from Production to Beta backends in SQL Server with ease.
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, [...]
Part 3: Destroy your linked tables on exit
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 [...]