[Pharmanaut]

Sorry,
MS-Access is just not up to the job for a such systems, it is simply not resilient or has sufficient performance. Pulling the plug when it is doing something and see what happens to your records.
Most new systems are based on SQL-Server and some GP systems use Oracle. The next big thing with pharmacy systems (and GP systems) will be "thin client" were your PMR software will not exist on your system, you will just use Internet Explorer and it will all look like web pages. Of course there will be lots of security in there as well. Our resident expert will probably confirm that our PMR suppliers are in effect working flat out on EPS at the moment to get EPS-2 (and variants) moving. As this is the UK, of course we have to have 4 variations, one for each country. Luckily all have decided to use the DM+D and SNOMED-CT coding.