Access Solutions

How to Quickly Update a Linked Table when the External File Name is Changed

Linked tables can be fantastically useful (although not all the time of course) – particularly when you're dealing with external info that regularly changes. A typical example might be when a supplier gives you access to their current monthly price file. But what happens when they issue the file next month, and the file name changes from "Pricelist-01-01-2016" to "Pricelist-01-02-2016"? The first thing that will happen is your link will break, so you'll have to manually update it. Every time...

Read more »

How to Import All Files within a Folder to Your Access Table

Data, data, data – without it a database would be pretty useless. So it’s no surprise that one of the most frequently asked questions when it comes to getting that data into your Access table(s) is – how can I make my life easier when I have to regularly import lots (and lots!) of files? As it’s such a common task, there’s obviously a number of ways to skin that particular cat, but here we’re going to look at just one – in my opinion the easiest – especially if you’re doing...

Read more »

How to Get the User Name of the Person Currently Using the Database via VBA

Need to know who in your business added a particular record? Or who updated it last? It’s a pretty common requirement, but unfortunately not one that Microsoft Access has built in functionality for. Simply adding a "last updated by" field to your table can (in many cases) be enough to meet most needs, but just how do you know who updated the record if Access can’t tell you? A little VBA code is all you need, as this article will show you. No need to create your own “login” form to...

Read more »