Access

Q&A with Access developer Juan Soto

Working in an ice cream factory in Chicago led Juan Soto to found IT Impact, Inc.,  an Access development consulting firm. The ice cream factory’s large Enterprise Resource Planning system required that he spend hours manually calculating whether a final batch of ice cream really made the company money. He had to factor the waste for every step of the manufacturing process and soon realized that he could automate the…

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

Ways to use Access data in Excel

When you need to use Excel to analyze data in an Access database, you have several options: you can copy and paste the data, create a data connection from Excel, or export the data to an Excel file. Your best choice depends on what you want to do.  Copy/Paste  If you just need some values from Access one time — and you don’t care whether the data changes in Access later…

Access

Query Criteria Part 3: prompting for input by using a parameter

In part 2 of this series, we considered using LIKE and wildcards in query criteria to find inexact matches. Good stuff – but what if you could get the query to apply criteria that are supplied when it is run? What if you could make a query ask for input? Good news! You can make a query ask for input, and it’s actually very easy.

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…