Outlook

Outlook and Office 365

The recent release of Microsoft Office 365 is a great opportunity for small and medium businesses to get the power of Microsoft Outlook and Microsoft Exchange Server together, for a lower cost than ever. If you’ve been using a POP3 or IMAP email account from your Internet service provider (ISP) or an email hosting service here are some reasons to try Microsoft Exchange Online with Office 365. The Microsoft Office…

Outlook

New Outlook Hotmail Connector released

We’ve got good news for those of you who read your Windows Live Hotmail accounts in Outlook. We have released an update to the Microsoft Outlook Hotmail Connector. This update brings a number of fixes and is required to continue using Hotmail accounts in Outlook. The version number for the updated Hotmail Connector is 14.0.5139.5001. To determine which version is installed on your computer, see the end of this article.…

Access

Power Tip: Improve the security of database connections

When linking to external tables using Open Database Connectivity (ODBC), Access offers to set up a Data Source Name (DSN). The DSN is quite convenient, giving us a graphic method to quickly build and specify an ODBC connection string without having to remember all of the syntax and parameters. Unfortunately, when the time comes for deployment, using a DSN can introduce some security issues. In this post, Access MVP Ben…

Access

Power Tip: Improve the security of database connections

When linking to external tables using Open Database Connectivity (ODBC), Access offers to set up a Data Source Name (DSN). The DSN is quite convenient, giving us a graphic method to quickly build and specify an ODBC connection string without having to remember all of the syntax and parameters. Unfortunately, when the time comes for deployment, using a DSN can introduce some security issues. In this post, Access MVP Ben…

Access

Power Tip: Supercharge conditional formatting by using a bit of code

Over the past few versions of Access, the product team has steadily added more conditional formatting functionality for forms and reports. For example, in Access 2010, you can add up to 50 conditional formatting rules for each object without having to write any Visual Basic for Applications (VBA) code. However, if you’re working in an earlier version, or if you just prefer to use VBA to perform formatting tasks on…