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…

Access

Use code to “undo” things in Access

One of the more common tasks on a computer is to undo something you just did by mistake. At least, it’s one of my more common tasks. CTRL+Z is my friend. But not everyone uses keyboard shortcuts – that’s why there’s an Undo button in the Microsoft Office user interface. Trouble is, sometimes folks just don’t see it. Moreover, in Access it’s possible that they can’t use the toolbar because…

Access

Power Tip: Maximize the use of TempVars in Access 2007 and 2010

Today’s tip is provided by Juan Soto, Senior Access Developer at AccessExperts.net. His blog is at AccessExperts.net/blog and you can subscribe to it by clicking here. Juan is a frequent speaker at Access user groups nationwide and was a participant in the last Access developers kitchen for Access 2010. He can be reached through his website or his blog. The TempVars collection has the ability to save you time, improve…

Access

Power Tip: Maximize the use of TempVars in Access 2007 and 2010

Today’s tip is provided by Juan Soto, Senior Access Developer at AccessExperts.net. His blog is at AccessExperts.net/blog and you can subscribe to it by clicking here. Juan is a frequent speaker at Access user groups nationwide and was a participant in the last Access developers kitchen for Access 2010. He can be reached through his website or his blog. The TempVars collection has the ability to save you time, improve…

Access

Going beyond Web Macros: Using Event Receivers & .NET with Access Services

Today’s guest blogger is Access MVP Ben Clothier. Ben is an independent contractor working with J Street Technology and Advisicon and was Technical Editor for the Access 2010 Programmer’s Reference. One challenge in Access Services is ensuring that the logic behind various objects will be portable between Access itself and the SharePoint site hosting the Access web database. To that end, the Access team has used macros to support the…

Access

Northwind 2010 Web Database is now available

We’re excited to announce that a longstanding Access tradition continues. A new version of the Northwind sample database has just been released. The best way to get to the template is to start up Access 2010, under Office.com Templates, click on Sample Templates, and then click on Northwind Web Database. You can also get the template here: Northwind Web Database.  As before, Northwind shows you what an Inventory/Orders system might…

Access

Power Tip: Password protect your VBA project

A question came in recently regarding whether you can password protect just the VBA code for an Access database, but not the rest of the database. The answer is yes! Here’s how to do it: In Access, press ALT+F11 to open the VBA editor. On the Tools menu, select <Database Name> Properties… On the Protection tab, select the Lock project for viewing check box. Enter and confirm a password. Click…

Access

Access 2010 and SQL Azure

This post comes from Russell Sinclair who is in New Orleans showing off the newest Access 2010 features at TechEd. Microsoft SQL Azure is a new cloud-based relational database built on SQL Server that provides highly available, scalable, multi-tenant database services hosted by Microsoft in the cloud. It eliminates the need to install, setup and manage SQL Server, freeing IT to handle day-to-day operations rather than having to manage and…