Access Database Recovery

How to Display Multiple Results in a Single Query Field in Your Access

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 asked to produce a report of how who were the top 5 sales people – in Descending order – for each month of the year, or the closest 3 stores to each customer, then you’re potentially left with wrangling with crosstab queries or...

Read more »

What to Do if You Get “Not Enough Memory” Error when Adding a Field via Access Design View

How many times have you tried to add a new field to an existing table and had the dreaded "not enough memory to complete this operation" error message? If the answer is none then you’ve been lucky – so far, but chances are that you'll have it at some point, so this article will explain how you can add a new field – even when Access doesn't think it can… Table changes – without the headaches I've lost count of the number of times I've tried to make a change to a table, whether it's...

Read more »

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 »