Database design - People and Organisations I don't get it. Do you mean an Access database? I think no, as (AFAIK) there is no Ajax in Access. Then why couldn't a middle layer (I mean some logic between the frontend and the database) deal with input validation? I know it is not trivial, but it is far from being impossible.
Performance issues moving 1 million rows between tables Could you elaborate on this a bit? Like why and how this would work, how it relates to other solutions? Probably adding proper formatting (code, capitals, punctuation marks) would also increase the value of your answer.