We’ve said it before, but it’s worth repeating - linked tables can be really useful in your databases for a number of reasons. But one big drawback of linked tables is performance – running queries against them, especially if they aren’t Microsoft Access tables (i.e. if they’re Excel, CSV, or DBF files). They can be painfully s l o w to work with. There are a few ways you can work around that – we’ll work with one way here, and that’s to convert a linked table into a local table. Sure – you...
Read more »
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 »
In this article we explore the tricky issue of linking data from one Ms Access Database to another.
You might have heard about importing or transferring data from one Access Database to another, it is done often, in a lot of scenarios. But moving ahead of the simple copy / paste technique, today we will be discussing about linking one Access database to another. This too is done in a lot of scenarios, like – when data from one table needs to be shared with data in another table, due to the...
Read more »
