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 [...]
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 [...]
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 [...]
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 [...]
