Recent content by DickyP

Arguably neither did the participants! ;)

People forget just how small and crowded the UK is: The USA has more than 40 times the land area (16 states are larger than UK), but only 4.9 x times as many people. Thus UK is some 812 % more crowded than the US.

Ah - nuances! Don't you just love them? The monarch in UK actually can make laws independent of Parliament, although it would be a reach to say her/she doesn't have their approval / acceptance. Such things as some Orders in Council are the monarch making laws, but these a best described as...

Technically you are wrong - ONLY the king makes laws in UK. Nothing passed by Parliament is law until it is given the Royal Assent. In reality, of course, you are correct.

The European Parliament does not make laws! It has no legislative powers, whatsoever. It merely endorses laws enacted by the European Commission. The parliament can recommend, but they can be (and often are) ignored

Consistent but seldom sensible! :D

The other palliative measure with these errors, which occur even if your database compiles, is to fix a well documented problem that's been around since Access 97 where your references get confused. To deal with this add any new reference, compile, then delete the new reference and recompile...

As you say my post does not really help to address the actual problem posed by the thread - just a bit of fond nostalgia. When I was building systems 'for real' the security plan was always in the system specification long before any detailed design let alone coding took place.

I am an enthusiastic user of RegEx in Access, but in this particular case I'd use another tool to edit/transform the data first, such as PowerGrep where you can keep playing with the data until you get it right.

The problem with this subject is that common sense doesn't apply at so many levels. And we all have the 'correct' answer don't we? Gun control doesn't seem to work as it just put guns into the hands of criminals. See my earlier post about gun laws in UK. Weapon control laws aren't thought...

Your description of what needs doing and how is spot on, however, I truly disagree with your description of Access security. It was simple and easy to use if you started with a proper usage/access plan and it worked well.

A lovely example! In English English we'd say twopenn'orth.

As a Brit who spent many years in the USA I was, and still am, amused by the problems of not quite understanding each other. Two minor examples of my own experience were: - the wife of an American friend of mine on her first time in UK looking totally blank when begin asked if she had a biro...

Saddest thing about this whole stream is that until Access 2007 the necessary security was built into Access!

Just realised I've also got an Acer Aspire 1825 laptop running Win 7 I've had since before about 2008, when I retired. Still running Office (including Access 2003) quite happily. Don't refer to it often, but when I do it works (albeit slowly) perfectly. Was highly innovative when I bought it...