Access

Access

How to save your Access SharePoint password

Recently, someone posted a comment on IT Impact Inc.’s blog asking how to get SharePoint to remember his password when he logged in via Access.  He wanted to avoid having to log in every time. Ben Clothier, a Senior Access Developer at IT Impact, knew the answer. He wrote a detailed blog post (with plenty of screenshots) that we’d like to share with you.  ITImpact has been building custom databases with…

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…