I paste a set of data from excel into Access, and always get the following sequence of nanny controls that are totally annoying and useless:
The Value you entered isn't valid for this field (ie, there are #N/As)
Do you want to supress further error messages telling you why records can't be pasted?
You are about to paste 4689 record(s)
Records that Microsoft Office Access was unable to paste have been nstered into a new table called 'Paste Errors'
Because the middle two are yes/no, I can't just hit enter when I hear a beep. Who in their right mind would say OK, Yes, then, when told they are about to paste 4000 records say 'no'? Why not simply ask us 100 times if we are sure, because, you never know, and it's all about protecting the user from himself. I spend more time trying to disable Microsoft protection, than fighting unauthorized users or viruses.