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...
Read more »If you’ve ever needed to produce a delimited list of field/query values alongside other information from your database you’ll know it can be challenging at best – and a task most people think isn’t going to be possible. If, for example, you’ve been...
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...
Read more »